Need excel macro Jobs

I need an excel system for One Drive that will enable me to effectively monitor my business' trash expenses. The following features should be included: - Data entry for each individual bill spent on trash. I'll manually enter the amount spent on each bill. - Calculation of total trash expenses over a given period. - Monthly reporting of trash expenses, to aid financial planning and cost analysis. Having experience in Excel, formulas, complex calculations and reporting will be handy for this project. If you're familiar with One Drive, that's even better. Perfect for someone who is detail-oriented, precise, and efficient.

I am in need of a skilled freelancer to carry out web scraping in a professional and timely manner. The ideal candidate will have significant experience in the field of data mining and extraction. Your task will be to scrape text content, images, and product information from specified websites. Please ensure you highlight your experience in your application. Upon completion, I'll need the scraped data to be organized and delivered in an Excel Spreadsheet format for ease of analysis. Key Skills: - Web scraping - Data mining - Data extraction - Proficiency in Excel, for the clean arrangement of data.

More details: What is the purpose of the Excel sheet data typing project? Data entry What type of data will be entered into the Excel sheet? Both numerical and textual data What is the source of this data? Manual entry

I'm looking for a professional experienced in Power Automate Desktop to autom...looking for a professional experienced in Power Automate Desktop to automate a task I regularly deal with. The task involves extracting specific 'pricing details' from multiple webpages, and subsequently transferring this data into an Excel file. Skills and Experience: - Proficiency in Power Automate Desktop - Expertise in web data extraction and management - Knowledge of Excel data handling Please note that the automation must be able to cover multiple pricing details - whether they are listed singularly or in package form, and accurately convey them into the Excel file. Prior experience with this type of automation is a plus. The successful candidate will have the capaci...

Bitte melde dich an oder Loge dich ein um Details zu sehen.

I need a professional to extract emails, phone numbers, and usernames from Instagram users' followers. These data are crucial to launching my marketing campaign. After the completion of extraction, I want the data to be delivered in an excel spreadsheet. Skills in Instagram API and data mining will come handy and are thus ideal for this job. An experience in extracting big data sets from social platforms will also be advantageous.

I need an expert with a strong background in Python to extract specific data from a PDF file. You'll need to accurately shift this data to a structured CSV or Excel spreadsheet. Key Responsibilities: - Browse a folder containing PDF files - Extract text-based information from the source files - Extract each line item and append it to the existing list if not add to the list - Focus on retrieving numeric data and dates specifically - Ensure the dates are formatted as 'DD/MM/YYYY' - Generate a log of processed files and errors if any Skills & Experience: - Python programming - Data extraction, wrangling, and analysis - Previous work with PDF data extraction strongly preferred - Attention to detail is vital, to ensure accurate data extraction - Unde...

I urgently need an expert in Excel VBA who is highly skilled to create a tool capable of storing passwords securely. This task is critical and needs immediate attention. Key Requirements: - Development of an Excel VBA sheet with password storage functionality - Emphasis on security measures: While I skipped the question related to specific security measures, the chosen freelancer should be competent in advising and implementing the most appropriate ones such as data encryption, file password protection or two-step verification to ensure the highest level of safety. Ideal Skills: - Proficiency in Excel VBA - Expertise in data security principles - Knowledge about password storage and encryption - Capability to work under tight deadlines Given the urgency of t...

I'm in dire need of a proficient professional with strong skills in Microsoft Excel, particularly with linking and integrating data across spreadsheets. The focus is on nutritional data, specifically numerical data. Key Project Requirements: - Experience in managing numerical data in Excel - Ability to flawlessly link different Excel sheets for seamless data retrieval - Hands-on ability to import nutritional data from a database to an Excel sheet - Strong attention to detail to ensure accuracy and consistency of imported numbers Your efforts will greatly simplify my day-to-day management of nutritional data. An understanding of nutritional data or related fields will be a strong advantage, though is not entirely necessary. Speed and accuracy are o...

I'm in need of a proficient freelancer who can assist me with: Creating a proof of concept web page in which an existing file, stored in OPENAI storage, is utilised as a reference during an API call. File types: To include: pdf, ms word, Excel, CSV, text, XML, JSON User acceptance: To be able to query openAI about the file and get responses that relate exclusively to the reference file. Code: Native JavaScript. Can use external libraries. Should run on any server without installing plugins. Specifications: - The file constitutes mixed data, encompassing both numerical and textual information. - The system should seamlessly interact with the entirety of the file. - The primary task involves integrating the API to fetch data from the stored file, read and analyse i...

I am in need of a unique yet straightforward website, primarily dedicated to sharing an event calendar and notes from various day trips. I would like it to be easy to update. Right now I have excel tables. Want easy to share and update (no public update). Can share what I have now. Want the ability to add a few links to other sites, to add a small number of pages or a subsite in case I start a small side gig - for example an airport shuttle service Key Features Required: Event Calendar: - The ability for me to add events, complete with crucial details like date and time. - Display of these events should be flexible, allowing both a monthly and weekly view. Day Trip Sharing: - Each day trip note needs to be in an individual blog post format. - I would also like an int...

I am in urgent need of a dedicated virtual assistant fluent in data entry for text and numbers into Microsoft Excel. The task at hand will involve: - Populating an Excel database with text and numerical information. - Using five different fields for each entry. An ideal candidate should possess: - Proficiency with Microsoft Excel and an understanding of its usage for data management. - An acute attention to details to ensure data accuracy. - Proficient typing speed for quick data entry. - Data management and administration experience are beneficial. I will provide the sources from where the data is and can be accessed for input into an Excel workbook I have built. See attached workbook. The tabs are broken out by states here in the USA. Pleas...

Looking for old Forex Excel files need IT, UK Leads if you have some lists give me the info how many have you got? info must have name, last name, email, phone number bulk needed around 1m per geo if you have it send me small image to see the fields, cost amount

I require a highly skilled Power BI professional to automate reports based on customer data currently stored in Excel spreadsheets. Tasks: - Familiarize themselves with the data structure in our Excel spreadsheets. - Use Power BI to automate the reporting of this data. Ideal Skills: - Advanced understanding of Power BI and its functionality, specifically in regards to report automation. - Experience with data analysis, particularly of customer data. - Expertise in Excel, able to work with complex spreadsheets. Your ability to work 'real time' using screen-share technology is essential. This will help ensure a seamless integration of your work into our existing system. Freelancers who have successfully conducted similar projects in the past will be highly r...

I'm in need of a proficient data entry specialist, particularly knowledgeable in Excel. The data to be entered is not just simplistic entries, it involves working with links between spreadsheets and complex formulas. Here's what I require: - Fascinating skills in Excel data entry - Proficiency in creating links between spreadsheets - Ability to handle complex formulas within Excel - Competence in creating both pivot tables and graphs based on entered data This project requires an individual with advanced knowledge in Excel, and strong precision to detail. The ideal freelancer should have excellent organizational skills and previous experience working with similar projects.

I'm seeking seasoned professionals who excel in website development, mobile app creation, and graphic design to bring my multi-faceted e-commerce concept to life. The scope includes: - Crafting an e-commerce website - Developing a corresponding mobile app - Deploying enticing graphic designs I aim to establish a platform for selling products/services, highlighting the necessity of expertise in similar business-oriented projects. Ideal Skills include: - Proficiency in e-commerce website development - Expertise in mobile app development, iOS and Android - Exceptional creative graphic design capability - Excellent understanding of UI/UX principles Proven experience in similar projects will significantly increase the chances of collaboration. Looking forward to innovative, ...

I am looking for a highly experienced Program Management Consultant to take the lead in designing, implementing, and maintaining operational processes for a large company. Key focus will be on rolling out and managing new processes, with a goal of increasing productivity and enhancing project delivery. What I'm looking for: - Proven experience in implementing new processes - Stro...Strong portfolio showcasing successful process improvements - Ability to optimize operations for enhanced productivity Successful freelancers should include examples of relevant past work in their applications. The ideal candidate can demonstrate past success in streamlining operations and effectively managing new process rollouts. Your proposal should clearly show your ability to take on and excel...

I'm in need of a skilled freelancer who is an expert in Excel 365 and specifically skilled in VBA automating tasks. The main function of this role includes: - Automating tasks in Excel 365 - Utilizing VBA to generate regular reports - Should work in Windows and Macbook both The ideal candidate for this project has strong experience in using Excel 365, with specific knowledge in automating tasks through VBA. I am especially interested in those who have a proven track record of generating regular reports using VBA. Please include examples of similar work in your proposal.

...company's B2B program as Excel and XML within a certain period of time. The B2B program installed on my computer was installed on my desktop with keys and passwords via remote connection. The information I want from this program; I want a program that can quickly capture the stock code of the product, product description, original number of the product, price of the product, image URL of the product, and stock quantities of the product in which warehouses within a certain period of time. After making this program, it should automatically upload this data to my own website, which I purchased with a ready-made theme, as soon as possible. I need someone who can integrate and do this. The ready-made themed site I purchased uploads data in bulk with an XML address and E...

I need assistance in extracting specific elements from 250 Excel spreadsheet addresses - specifically, the city, state, and ZIP codes. The purpose of this extraction is ultimately to import this data into a specialized software. Ideal Skills: - Strong grasp of Excel - Experience in data extraction and manipulation - Familiarity with data importation process for software applications Deliverables: - Clean and well-organized list of city, state, and ZIP code data extracted from 250 addresses - Recommendations on best practices for importing this data into software.

More details: What subject is the classwork for? vba What is the specific task or problem you need help with using VBA? Creating macros for repetitive tasks What type of macro functions should the script perform? Filtering and sorting data

...I am currently a student in a business school and I am preparing for a makeup session regarding Excel VBA. Unfortunately, during my preparation, I encountered difficulties using ChatGPT for the exam, which was not successful. Additionally, I faced a delicate situation when it turned out that I had used a portion of a friend's work to help me, which was noticed by the professor since my friend's name was on the Excel file. I am simply seeking an expert specializing in automating tasks in Excel using VBA. The main focus of this project revolves around automating data entry processes. Here, efficiency and accuracy are paramount. The main responsibilities include: - Automating data entry in Excel using VBA - Enhancing the speed and accuracy of data i...

More details: What subject is the classwork for? vba What is the specific task or problem you need help with using VBA? Creating macros for repetitive tasks What type of macro functions should the script perform? Filtering and sorting data

I am in need of a freelancer who is an expert in Excel to assist me with data analysis. The ideal candidate should have advanced skills in Excel and should be proficient in general data analysis techniques. The specific tasks that I require help with include data analysis, formula creation, and formatting and design. The freelancer should also be experienced in working with a variety of data sets. If you have the required skills and experience, please apply for this project.

I'm looking for an Excel expert to create a spreadsheet for me. Here are the key features I want: - Automatic calculations: I need the spreadsheet to automatically calculate sums and percentages. Prior experience in creating automatic calculations in Excel is important. - Graphs: I would like the spreadsheet to include bar graphs. This will visually display the data in digital format, so freelancers with skills in creating and managing graphs in Excel would be ideal. The final deliverable should be a user-friendly Excel spreadsheet that meets the above requirements. As such, attention to detail, proficiency in Excel, and a knack for visually representing data are all necessary skills for this job. I want to make an Excel that allo...

I'm in need of an experienced virtual assistant with strong capabilities in web scraping. Key project responsibilities include: - Scraping text content and images from a test website. - Ensuring the data is accurate and comprehensive. - Organizing scrapped data in an Excel spreadsheet or a csv file. Keen attention to detail is critical. Applicants with prior experience in web scraping, data extraction, and data management, who are comfortable with Excel functions, will be ideal for this project. Please bid on an hourly basis for your time and explain who you will charge by the hour. I'm assuming that you will need to set up the scraping tool, which might take some time, then do the scraping itself from about 2,500 website pages, and then make sure t...

I require a proficient assistant with expertise in data entry, Excel, Word and Adobe Photoshop. The tasks involve: - Data Entry: Handling data entry tasks, few in number (fewer than 50 entries), which includes handling mixed data i.e. numeric as well as textual data. - Excel and Word: Manipulating and analyzing said worked data using Excel functions and creating detailed reports or documentation using MS Word. - Photoshop: Require basic graphic editing skills in Adobe Photoshop. Ideal skills for the job would be attention to detail, good command over Microsoft Excel and Word functionalities, and fundamental Photoshop skills. Past experience in data entry and graphic design would be highly appreciated.

I need someone to convert 20 PDF files into Excel spreadsheet format. Secondly, once converted to Excel format, I need a slightly new design (colour scheme) to the existing design found in the PDF files. If you could create several sample designs of how to represent the data in the PDF files in a different way (style?) in Excel? See attached 1 x sample PDF file to convert

I require a dependable and sharp personal assistant with a Bachelor's degree in engineering, possessing profound knowledge and fluency in English. This role involves a monthly salary of 500 USD and demands a high level of availability and smart handling of various tasks that are crucial to my personal and business needs. The assistant I'm looking for should excel in: - Managing my emails and setting appointments efficiently - Undertaking research-oriented tasks alongside adept data management - Facilitating the tasks with ChatGPT for diverse purposes - Seamlessly handling Airbnb business-related tasks including managing reservations, bookings, and ensuring guest satisfaction - Coordinating with housekeeping services ensuring the property is well-maintained, alongside regu...

I require a freelancer to create a dynamic bar chart that represents the changes in my agricultural product's production over the last 30 years. K...bar chart should reflect the comparison of yearly production versus previous years. - Displaying the data dynamically to show changes on a yearly basis. - Importing data from a spreadsheet format to be presented in the chart. The ideal candidate for this project should have robust experience in data visualization and analysis, with proficiency in tools such as Excel and data visualization software like Tableau or PowerBI. They need to practice attention to detail and have the ability to interpret and represent complex data in an easy-to-understand and aesthetic graph. Familiarity with agricultural data or past work in simil...

...updated every second. Example: I will give Seconds to Minutes Interval(30 sec to any Minutes) value is one cell, If i give value in excell cell, It start copy the live data value in Ex: Live data in Col A If give 1 min interval A col value copied into F col if one minutes end A col value again copied in G col G-F value stoted in H col then G col value assigned F col- Repeat this process in Excel VBA I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 175 INR and Good review, Dont expect more I am not big fish. it is difficul...

As a manufacturing business, we are in urgent need of an Excel expert who can efficiently create a comprehensive daily production report. This report will play a crucial role in tracking and informing us on: - The quantities produced each day - The quantities produced processed through different process - Purchase quantities from Outside - Monitoring dispatch - The respective production time for each product - Any machine downtime that occurs Each of these factors are vital elements to monitor in our production process. In addition to a total quantity count, we're also interested in having a breakdown of quantities produced, batch-wise. Ideal candidate should: - Have excellent skills in Excel, particularly in advanced functions and data visualization - Be a...

More details: What type of data do you need to enter? Text data What is the source of your text data? Digital files What type of digital files are the data in? Excel spreadsheets

In need of a professional to design and implement a Power Automate flow for auto-generating and sending reminder statements to my firm's clients, based on the information provided via a spreadsheet. Key Project Elements: - Developing a tailored email reminder system to ensure timely payment from clients. - Utilizing input data from a detailed spreadsheet. This includes specifics such as customer names, owed amounts, invoice numbers, and other necessary details. - Configuring the platform to dispatch the statements through email. Expectations: - Detailed understanding of Power Automate is essential, previous experience with similar projects would be a plus. - Familiarity with spreadsheet parsing would be beneficial. - Superior attention to detail, assuring all client d...

I'm on the hunt for someone adept in social media advertising, influencer marketing, and email marketing. Your task will be to effectively promote my digital marketing product to entrepreneurs and regular day people who want to make passive income with digital marketing. My product boasts the key benefit of increased website traffic. To excel at this job, you'll need outstanding skills in digital marketing channels, an understanding of the specific target audience, and a knack for persuasive selling. A successful sale of the $497 course means a 20% commission for you. Let's step up the digital marketing game together.

Adaptar planilha existente para melhor eficiência e design mais bonito para apresentação. a planilha deve atender mulheres executivas que buscam conhecer suas despesas, e alcançar a sua independência financeira para futura aposentadoria ou independência financeira do marido. levando em consideração seus investimentos, inflação e media de rentabilidade de seus investimentos.

I need professional guidance on creating custom modules on a self-hosted ERPNext 15. Specifically, I need a tutorial tailored towards the Data Analytics and CRM sections of the software. The custom module should incorporate the following functionalities: - Data visualization - Customer segmentation - Contact communication history For seamless operation, the module should be able to integrate data from the following sources: - ERPNext platform's database - External APIs - CSV/Excel files The ideal freelancer for this task should have a robust understanding of ERPNext software and have experience in module customization. Data analytics and CRM specialization as well as proficiency in integrating diverse data sources will be a significant asset. The ability to cle...

looking for java script expert for the JavaScript Macro Development to sheet automation the task is - - Writing a JavaScript macro to duplicate the last visible sheet within a file and providing it with a new name as a part of an automated procedure. - Once duplicated and renamed, the new sheet should be moved to a specific location inside the file. - Modifying the contents of the copied sheet as necessary. - Implementing a notification function once the procedure is completed successfully. - Adding protection to specific cells within the sheet. more detail on chat

I am looking for a freelancer who can assist me with the following tasks: Data entry in Excel: - I need help with entering data into Excel spreadsheets. - The freelancer should be proficient in Excel and have experience with data entry tasks. - Accuracy and attention to detail are crucial for this task. Autocad 2d: - I also require assistance with 2D drawings in Autocad. - The freelancer should be skilled in Autocad 2D and have experience with creating accurate and detailed drawings. - Knowledge of architectural or engineering drawings is preferred. Autocad 3d: - Additionally, I need help with 3D modeling in Autocad. - The freelancer should be proficient in Autocad 3D and have experience with creating realistic and detailed 3D models. - Knowledge of ar...

Hi Gupta I have a PDF which I would like converting to Excel please. The volume is 6 pages, printed 2 pages wide (there are 18 columns) it is 3 pages long. Please confirm availability and time needed to complete. Regards

I'm in need of a proficient Excel expert who can develop a dashboard for courier pricing data. The focus of this project is to allow analysis and comparison amongst different courier companies to determine the most cost-effective options based on weight categories. The desired end product should function as a calculator and feature: - Comparison of pricing between various courier agencies to identify the most economical options - Filter and sorting capabilities based on weight categories Based on these needs, the ideal candidate should have extensive experience with Excel, particularly in creating interactive and functional dashboards, and be able to work within the deadline of March 26th. You should also be knowledgeable in data analysis to capture significant ...

I'm seeking an experienced Excel developer to bring organization to my data. The main focus of this project will be to create a structure within Excel that will allow for simple and intuitive navigation. Key responsibilities: - Create an organized structure for a large amount of data - Build an easy-to-use system for future data entry Ideal skill set: - Sound understanding of Excel capabilities - Proven experience in organizing and structuring data within Excel - Detail-oriented and highly organized To apply, please provide: - Evidence of past projects similar in nature - A detailed proposal on how you plan to tackle this task. Your main goal will be to create a system in Excel that allows for efficient and organized handling of data. Looking ...

I'm seeking a proficient Excel expert capable of creating an efficient lookup file for me. The premise is to compare product names and SKU numbers across a medium-sized dataset, ranging from 101 to 1000 rows. Time efficiency is paramount, as the project needs to be completed ASAP. Ideal bidders will have: - Outstanding proficiency in Excel, particularly in creating and managing lookup files. - Exceptional attention to detail to ensure accuracy in comparing product names and SKU numbers. - Ability to deliver a fast turnaround time as this project needs immediate attention. Thank you in advance for your time and bid.

I need an experienced Excel user to input numeric data into an Excel sheet in tabular form. This project is focused on data entry and does not require any formula or calculation implementation. The ideal candidate should have: - Experience with Excel data entry - Diligence in maintaining data accuracy - Ability to work effectively with numeric data - Typing proficiency to ensure target is met in the given time Please ensure high accuracy, as the data entered will be used internally. The project timeline is flexible and can be discussed further during the hiring process.

More details: Which specific data do you want to extract from your Facebook account? Group name, link, public/no public, number of user For which specific groups do you want to extract data from your Facebook account? I am connect...specific groups do you want to extract data from your Facebook account? I am connected to hundreds of groups, I would like to extract their data What specific data do you want to extract from each group? Group name, Group link, number of member,, public or no public group I am connected to hundreds of groups, I would like to extract their data. I would like to save the extracted data in csv or excel. Group name, group link, number of members in the group, whether the group is public or not - that's all the data I'm interested in from the grou...

As someone with an advanced level of experience in Tableau, I'm on the hunt for equally qualified professionals who can assist me greatly in data visualization tasks. The successful candidate should have: - Expertise in working with large data sets within Tableau - Proficient skills in using Excel or CSV files as data sources - Exceptional ability in portraying complex data in a simple and visually appealing manner. Your top-notch skills in developing insightful visuals are what I require for my project. Join me, if you're all about turning raw data into striking visuals.

I need a specialist to develop and implement an operational dashboard on Tableau. I intend to use Excel spreadsheets as the main data source. Key requirements: - Proven experience in creating interactive dashboards in Tableau - Familiarity with Excel and data interpretation - Experience in representing operational metrics visually Ideal Freelancer: - Strong background in data analysis - Proven experience with Tableau - Understanding of operational KPIs would be advantageous The primary focus for the dashboard will be on operational metrics. This is crucial to the overall success of the project. Your expertise in crafting engaging, insightful visual representations of complex data will be key. I look forward to seeing your previous work and discussing how we can ...

I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. Your guidance through this d...

I need a professional with proficiency in Microsoft Excel to develop a comprehensive warehousing spreadsheet for my furniture delivery and installation operation. The spreadsheet will be organized by days of the week, with each delivery contained in its own cell. Key information required in each cell involves: Customer name, Brand of furniture, Order number, item/pallet quantity (breakdown for both), initials of the person who received the delivery, and an additional note field for recording any damages upon receiving the delivery. ` The sheet will need to show our 3 current warehouse locations. Essential skills: - Microsoft Excel (intermediate to advanced level) - Data management and organization - Understanding of warehousing and delivery processes...

I have a project that requires precise date entry into an Excel sheet. The specifics of the project include: - Typing dates from a digital document into an Excel sheet. - All dates should be inputted strictly using the DD/MM/YYYY format. Ideal Skills/Experience: Candidates with exceptional attention to detail are highly preferable. I am looking for someone who has proficiency in Excel and has a track record of precise typing. Ability to handle digital documents with ease is also a must. Your accuracy and speed will be key for this project. I look forward to receiving your bid if you can meet these requirements!