Vba macro excel jobs
I am looking for a freelancer who can assist me with data entry from documents. The ideal candidate should have experience in accurately and efficiently transferring data from PDF files into a spreadsheet. Skills and Experience: - Proficiency in data entry fro...am looking for a freelancer who can assist me with data entry from documents. The ideal candidate should have experience in accurately and efficiently transferring data from PDF files into a spreadsheet. Skills and Experience: - Proficiency in data entry from documents, specifically PDF files - Attention to detail to ensure accurate data transfer - Familiarity with spreadsheets, particularly Excel - Ability to work efficiently and meet deadlines - Previous experience with small-scale data entry projects (1-100 pages) is ...
As a small business owner, I am looking for a solution to better track my profits and expenses. Currently, I'm using Excel spreadsheets, but I am looking for something more. Specifically,I need a profit tracking system that can integrate with other systems and can provide me with real-time updates and customized reporting. I have been looking into web-based options, such as Google docs, but I'm open to any standalone application as well. I'm seeking a talented freelancer to help me create the perfect profit tracker.
About the Task: We are seeking a Freelance Spreadsheet Calculation Specialist for a straightforward, one-time task. The primary responsibility is to add formulas and calculate sums in an existing financial spreadsheet. This task is essential for finalizing our monthly financial reporting. Task Details: The specialist will be provided with a spreadsheet that contains data for a month's sales of various products and overhead expenses. The task involves inserting formulas to calculate totals and subtotals. Key Responsibilities: Insert formulas to calculate daily totals for sales transactions. Calculate the monthly total for sales and overhead expenses. Compute the net profit by offsetting total sales against total expenses. Ensure formulas are correctly applied and functioning as inte...
We want to create a WIX email marketing campaign targeting landscape contractors found on the state website. enter zip code 28037. there are about 300 companies. Paste the First Name, Last Name, Email, City, into the WIX email template. a sample csv file is attached for reference.
I am looking for some native English and Hindi typing experts. The project involves copy typing and data entry from PDF to excel sheet. I need only native Hindi speaker who is also fluent English speaker. I need high-quality and accurate services.
I am looking for a freelancer who can help me with sorting and formatting six Excel files. The data in these files consists of text and images. Criteria for sorting and formatting the data will be provided, so the ideal candidate should be able to follow specific instructions. The desired format for the final output is a Master Excel Workbook with six sheets, each representing one of the original Excel files. Skills and experience required for this project include: - Proficiency in Microsoft Excel - Attention to detail in sorting and formatting data - Ability to work with text and images in Excel - Strong organizational skills to create a Master Workbook with multiple sheets.
...%20system&utm_campaign=Search-Brand-UK-AU-UAE&utm_source=adwords&utm_medium=ppc&hsa_acc=9006684373&hsa_cam=17758114718&hsa_grp=139850400238&hsa_ad=610448504775&hsa_src=g&hsa_tgt=kwd-343193918371&hsa_kw=inflow%20inventory%20system&hsa_mt=e&hsa_net=adwords&hsa_ver=3&gclid=CjwKCAiA0syqBhBxEiwAeNx9Nz3czRuqFEKUzKMNW1VyR-BtVXisPiT0ZhVwD5JTpk69KEDiaMuKYxoCTXMQAvD_BwE Skills and Experience: -Mostly Excel based software for inventory and stock control, with API links to Quickbooks, Google Calender and Email link, please look at the link above for all software features (connections to other apps are specified during discussion) - Must have experience in software development for Windows - Proficiency in programming languages such a...
I need a freelancer who can help me with a data analysis project. The purpose of the Excel document is data analysis, and I am looking for someone with experience in creating custom formulas to help with the analysis. The ideal candidate should also have experience with data input, as I will need help inputting the data into the document. Overall, I am looking for a skilled Excel user who can help me with this project.
I'm looking for an experienced automation specialist to help me get up and running with automating various tasks. I need someone who is familiar with the latest automation tools and technology, and can develop a solution that works for my specific needs. I want to employ an automation tool or software such as Microsoft Excel, Mailchimp, or Buffer, but am open to other recommended options. The frequency of automation can range from daily to monthly, depending on my requirements. I'm committed to finding a qualified professional who can develop an efficient and reliable automation system for me.
My team needs assistance with a project that involves data analysis in Excel and the creation of a PowerPoint presentation with cue cards. We specifically need help with statistical analysis and modeling in Excel, so someone with sizeable experience is desired. The presentation should be at an advanced level with animations and interactive elements. As far as the cue cards, we’re open to anything. We’re looking for someone who can accurately analyze the data and have creative ideas for making the PowerPoint presentation stand out. Due to the level of work expected from the freelancer, we are willing to provide competitive compensation. Must be open to make unlimited changes as requested and finish the project within 8-12 hours. British English Only.
I need to design simple calculator application in IOS for apple mobile device , the application to be build in and excel sheet format is available to be used for the calculator. the goal is to calculate the productivity loss by migraine in US$.in F2 cell in the excel sheet
I am looking for an Excel expert to help me with a data analysis problem. I have a large data set with over 1000 rows that I need to analyze. Using Excel (or VBA), I want a reusable dashboard built that calculates all the various combinations of numbers that equal a specific amount. For example, from a list of 5,000 numbers I want to know all possible combinations that equal $1,236,254.16. See the attached files for an example of a data set and an example of what the output might look like. Preferably I want this to run on both Excel for Mac and Excel for Windows. The ideal candidate must have experience in data analysis and be proficient in Excel. Requirements: - Strong knowledge and experience in data analysis using Excel - Ability t...
I need to design simple calculator application in IOS for apple mobile device , the application to be build in and excel sheet format is available to be used for the calculator. the goal is to calculate the productivity loss by migraine in US$.in F2 cell in the excel sheet
We are using a quoting software that uses Word templates and Macros. The template is attached to the project. 1. On Page1, Prepared for: SoldToFullName and SoldToEmail aren’t working. 2. On Page 2 & 3, the header graphics go awry when doing the merge in Quotewerks. 3. On Page 2, We need the products separated by category and subtotaled under each category. 4. On Page 3, none of the ship to or bill to info is being pulled over. 5. On Page 3, we need each category listed with a subtotal for that category and then totaled below that. 6. On Page 3, we need the signature lines fixed. They also go awry when doing the merge in Quotewerks. This is what support said from the quoting software: "As for the sections you have to use an item type filter. So you would need to settle on ...
I am looking for a freelancer who can assist with spreadsheet formatting, specifically focusing on data visualization and charts. Skills and experience required: - Strong knowledge of spreadsheet software (e.g. Excel, Google Sheets) - Proficiency in formatting tools such as fonts, colors, and borders - Expertise in creating complex calculations and formulas - Experience with data cleaning and manipulation - Ability to transform rough data into visually appealing charts and graphs Project details: - The project involves working with rough data that needs cleaning before visualization. - The timeline for completion is within a week, so the freelancer should be able to work efficiently and meet deadlines. If you have the necessary skills and experience, and can complete the project...
Lead Generation List for specified industries (100 - 200) We are looking for a freelancer who can help us generate a targeted lead mixed list for the real estate industry, healthcare providers, and maintenance services, specifically small & medium businesses. Target Geographic: USA, Canada, New Zealand Contact Information: Name, title, business Email, and website, supplied in excel. Contact requirements: CEO, Owner or equivalent. If unavailable then COO or equivalent (head of operations, operations director, etc). Specific Criteria for Leads - The leads should be individuals or small businesses within the specified industry, and must have a working website. Skills and Experience Required - Proven Experience in lead generation. - Strong ability to identify and target p...
Hello, I am looking for help to create an email message by selecting multiple rows in Excel and creating a Table of a few selected columns. Data set is in the "Aging" Tab. Sample Table that I would like shown in the "Email" tab. Would like the ability to change/delete columns as needed. Body of email message would like to be able to add some text to message. Same email format provided. We have PDF documents that would need to be linked to column E (Invoice Number) and would like to have those PDF's added to email message as an attachment. PDF documents are named the same as the Invoice number. Example Invoice 1 is 1.PDF. File location example C:AR Need the ability to highlight the rows I want to be included (example if I select only rows 5, 6 and 7) to ...
I am looking for a Finance Excel Expert to help with data analysis tasks in Excel. The specific tasks required for this project include data analysis. Skills and experience required: - Strong proficiency in Excel - Experience in financial modeling and budgeting - Ability to perform data analysis and provide insights based on the data The client has a specific dataset for the analysis, so the freelancer does not need to find the data. The deadline for this project is within 1 day.
I am looking for a freelancer who can help me with a research project. I need someone to scrape email addresses of users based in Dubai. Requirements: - Experience in web scraping and data extraction - Proficiency in using scraping tools and techniques - Attention to detail to ensure accurate data collection - Ability to deliver the email addresses in an Excel file format The purpose of scraping these email addresses is for research purposes. I do not require the emails to be sorted or categorized based on industry or job title. I simply need a comprehensive list of email addresses of users in Dubai. If you have the necessary skills and experience, please submit your proposal.
...forward task, program an excel table/database that scrapes certain data directly from crypto exchanges. For completing this task correctly I guarantee to write a huge professional review that would get you multiple clients in the future as well as I also guarantee future jobs if the task is completed correctly. (SHORT PREVIEW/SUMMURY OF THE TASK) Easy job, program an excel table/database that scrapes certain data from crypto exchanges in sets(variations) of 3 crypto pairs per row with an option for each column (and/or for all columns at the same time) to show data in real time or right now/every 1 sec/ every 1 min/ every 5 min/every 1 h/ every 24h/ every 7 days/ every month/ every year/all or from the beginning. (DETAILED DESCRIPTION OF THE TASK) I would need an exce...
I am looking for a freelancer who can help me with a research project. I need someone to scrape email addresses of users based in Dubai. Requirements: - Experience in web scraping and data extraction - Proficiency in using scraping tools and techniques - Attention to detail to ensure accurate data collection - Ability to deliver the email addresses in an Excel file format The purpose of scraping these email addresses is for research purposes. I do not require the emails to be sorted or categorized based on industry or job title. I simply need a comprehensive list of email addresses of users in Dubai. If you have the necessary skills and experience, please submit your proposal.
I need someone to correctly link the people who are expired, in this case it is only 1 and it is showing 15 and the total is 227 but the total must include active and inactive which is a total of 433. Look at the attachment to understand please.
Data Entry Specialist Needed for Typing Excel Spreadsheet Skills and Experience: - Proficient in data entry from spreadsheets - Excellent typing skills - Attention to detail - Familiarity with Excel Project Details: - I am in need of a data entry specialist who can accurately type information from an Excel spreadsheet. - The document should be typed in the Excel format. - The project involves typing 1-100 entries. - The ideal candidate should have excellent typing skills and attention to detail. - Familiarity with Excel is preferred. If you have the necessary skills and experience, please submit your proposal along with any relevant samples of your previous work.
Please look at the below spreadsheet Look at the URLs Fill in the required headers Image - Product Image Size - Product Size Sell Price - The products price For products that have multiple sizes you will need to add multiple lines
Data Transcription Project I am looking for a freelancer who can assist me with data transcription. Skills and Experience Required: - Proficient in data transcription - Attention to detail and accuracy - Familiarity with spreadsheet software (e.g. Microsoft Excel, Google Sheets) - Ability to transcribe less than 50 pages of data Specific Requirements: - Transcribe data into a spreadsheet format - Ensure accuracy and organization of data If you have experience in data transcription and can efficiently transcribe less than 50 pages of data into a spreadsheet, please submit your proposal. Thank you.
Data Entry Project: Data Processing in Excel Skills and Experience: - Proficiency in data processing using Excel - Strong attention to detail and accuracy in data entry - Experience in organizing and analyzing data - Familiarity with Excel functions and formulas for data manipulation - Ability to work efficiently with small data sets (less than 1000 entries) Description: We are looking for a freelancer who specializes in data processing using Excel. The project involves organizing and analyzing a small volume of data (less than 1000 entries). The ideal candidate should have experience in data entry, data cleaning, and data conversion. Attention to detail and accuracy is crucial for this task. Proficiency in using Excel functions and formulas for data ma...
Exporting Sales Data for Bedsheets from India - I am looking for a freelancer who can help me export sales data for bedsheets from India. - The specific data that I need to export is sales data. - I would like to have all available sales data, so there is no specific timeframe. - The data should be formatted in an Excel file. - The ideal freelancer for this project should have experience in data export and be proficient in working with Excel files.
I ma reposting this project due to several time-wasters and failed starts.I am looking for a freelancer who can convert my Excel workbook into a standalone desktop app. The app should be compatible with both Windows and Mac operating systems. Key requirements: - Budget is max $125 AUD - The app should have an exact replication of the workbook, including all functionalities and formulas. - There is no need for additional features or a simplified version of the workbook. The deadline for completing the project is flexible, with no strict deadline. Ideal skills and experience: - Proficiency in Excel and VBA programming - Experience in developing desktop applications for both Windows and Mac - Attention to detail to ensure an accurate replication of the workbook If yo...
I am looking for a skilled developer who can build an application in ArcGIS that automates the process of uploading an Excel file, integrating the user-provided data with an API and creating a mapping visualization that can be downloaded as a shapefile. Purpose of Mapping Visualization: - The main purpose of the mapping visualization is to create an easy to use drag and drop application that is automated for the user. Database: - The client already has a database where the Excel data would be uploaded. Map Interface Customization: - The client requires a highly customized map interface with unique features and design. Ideal Skills and Experience: - Proficiency in ArcGIS and experience in developing applications using it - Strong knowledge of database management and int...
I am looking to get a power BI dashboard created. The dashboard should use Excel spreadsheets as the main data source, and include Charts as visualizations. It must be an interactive dashboard allowing for users to filter and drill down data. If you have the expertise necessary to complete this project, please reach out to me and we can discuss further details. Thank you.
I have an assistant that works with me physically in my office that needs basic computer training. She is originally from Bangladesh so you can speak native language with her. She need to learn to double click better, control folders and tabs, find files, attach files, fill in online forms, copy paste material, save files and basic control in excel and google calc. She also needs to learn google translate. If you are intrerested please write me back.
...Freelancer.com Hard work and timely delivery will earn you quick payment and a 5-star review ************************************************************************************************* I have an Excel sheet(attached) :x:/g/personal/saikat_ghosh_entertainment_com_au/EeUKmn1pxhVNo9wKhUp88t8BAg1jtpllTIVuIKZiOkl-LQ?e=idK65b Each row has the person's name and previous organization. You'll need to find the email addresses of those whose email addresses are either: 1. Blank 2. Deliverability score of less than 60% The information has to be filled into an Excel sheet and returned to me within 3 days. I will randomly check a few records for accuracy before releasing the final milestone, so please work carefully and try to finish as quickly as possible
I have an assistant that needs basic computer training. She is originally from Bangladesh so you can speak native language with her. She need to learn to double click better, control folders and tabs, find files, attach files, fill in online forms, copy paste material, save files and basic control in excel and google calc. We can pay 5 usd per hour for this. If you are intrerested please write me back. Regards
Job Description: ...Excellent attention to detail and accuracy. Ability to work independently and meet deadlines. Strong organizational and multitasking skills. High level of integrity and confidentiality in handling sensitive data. Preferred Qualifications: Familiarity with industry-specific terminology and data. Previous experience in data entry within [industry]. Proficiency in Microsoft Excel or other relevant software. Application Process: Interested candidates are invited to submit their resume, along with a brief cover letter detailing their relevant experience in data entry. Shortlisted candidates will undergo a data entry assessment to demonstrate their skills. We look forward to welcoming a dedicated and detail-oriented Data Entry Specialist to...
I wish to get easy access to ohlc values of banknifty, nifty options strike prices at selected time frame (say 15 min timeframe). Should be filtered for latest expiry date for the given options. This data will be used for further analysis, so the data should be easy to manipulate in different scripts. (Note: I could subscribe to any apis like zerodha kite connect if that is needed). Example: If i wanted to check the ohlc values for banknifty 43000 put for the upcoming expiry today for opening 15 min candle, then i should be able to see open value at 9:15 and close value at 9:30, along with HL values. The expiry dates would have to dynamically change.
I am looking for a Tableau expert to create a dashboard for me. Data Sources: - The dashboard needs to connect to Excel. Visual Representation: - Multiple charts/graphs as per requirements. Expecting 2 dashboards with answers to specific questions.
I am looking for a freelancer who can create an Excel pivot table and generate a statistics report from a CSV file spanning the past 10 years. The specific statistics that need to be included in the report user profile analysis Chart Type: I would like the pivot table to be presented in a bar chart format and line chart to show trending. Time Period: The data should be broken down annually. Ideal Skills and Experience: - Proficiency in Excel and pivot table creation - Strong understanding of statistics and data analysis - Experience in generating reports from CSV files - Knowledge of creating bar charts in Excel - Attention to detail and ability to accurately present data in a clear and concise manner. example data: firstName LastName Princess Maxima Center for pe...
I will give you the PPTX and the Excel. There are a dozen or so boxes on the slide. I need five of those boxes to be filled with data from an Excel. I need to be able to add/change the data in the Excel and rerun the PPT macros to create additional slides. This will be set up 1 time and run time and time again to create hundreds of slides. The deliverable - The PPTX with Macros. Short explanation on how to run it. Defining success - We are able to drop new information into the Excel and then open the PPTX and run the macros to create new slides. And be able to repeat the process whenever we want.
I am in need of a virtual assistant to help with entering data for billable hours. Tasks include: - Extracting and summarizing data from emails and documenting it on a spreadsheet The ideal candidate should be familiar with Excel/Google Sheets. HIPAA compliance is required.
I am looking for a freelancer to create an Excel food cost calculator based on the design that I will provide. The calculator should be able to handle multiple types of costs and prices, including raw food cost and quantity, as well as prepared meal cost and sales price. The calculator does not need to have any additional features such as graphs or charts. Ideal skills and experience for this job include: - Proficiency in Excel and creating complex formulas - Experience in designing and formatting Excel spreadsheets - Attention to detail and accuracy in data entry - Understanding of food costing and pricing principles.
Excel spread sheet required to track the movement of a land slip. The data is for a monitoring survey project. The data is received about every month, each data set has a title with the date in the title. The data is received as Point, Easting, Northing Height Code. I have attached the data sets. 220314 Base was the first survey, the number is the date backwards , so it was completed on 14/03/22. This is the first survey and the remaining data will need to be compared to this, as well as compared to the last survey. The raw data sets are attached. The point numbers are different every run, but the code can be used to compile the data. Also attached are 2 attempts to track and visualise the data. Attempt 1 and Attempt 2 where attempts to show the data, they are n...
I am looking for a freelancer who can help me with financial reporting automation for my business. I have created my own spreadsheet, but I need it to be entered in accounting form. Ideal skills and experience for this project include: - Proficiency in spreadsheet software such as Excel or Google Sheets - Knowledge of accounting principles and financial reporting - Experience in automating data entry and generating financial reports The financial reports need to be generated daily, so the freelancer should be able to set up an automated system that can generate the reports on a daily basis. This will help me track my financial metrics and make informed business decisions.
Need help in financial planning and analysis project. Most of the work might involve working with Microsoft Excel and creating reports for month end and quarterly reporting processes.
I am looking for a freelancer who can obtain a B2B lead generation list for the manufacturing industry. Target Industry: Manufacturing Geographic Location: Australia Contact Information: Name, title, location and business Email, supplied in excel. Contact requirements: CFO or equivalent (head of finance, finance director, finance VP, etc). If unavailable then COO or equivalent (head of operations, operations director, etc). Contact must reside in Australia. Business size requirements: to be between 200 & 1000 headcount. Please advise cost, leadtime & provide examples of your past work and your approach to lead generation in your proposal. Cost should be per 100 leads
Project Description: We are looking for a skilled VBA developer to create a robust automation process that takes the latest product information from an Excel spreadsheet and populates a PowerPoint presentation template with this data. Our Excel workbook contains multiple rows of product data, with columns for 'Product Name', 'Description', and 'Price'. The task is to capture the last entered row of product data and insert it into corresponding placeholders in a PowerPoint slide, creating a seamless proposal presentation. Objective: The goal is to streamline the creation of product proposal presentations, ensuring the latest product details are always presented without manual copy-pasting. Scope of Work: Excel Setup: Structure the...
Project Title: Marketing Calendar Creation in Excel Description: I am looking for a skilled freelancer who can create a marketing calendar in Excel. The calendar should be organized by month and should be flexible and editable. Key Requirements: - Experience in creating marketing calendars in Excel - Proficiency in organizing and structuring data in Excel - Ability to create a user-friendly and visually appealing template Project Details: - The marketing calendar should be organized by month, allowing for easy navigation and planning. - The calendar should be flexible and editable, allowing me to make changes and adjustments as needed. - I do not have specific marketing activities or tasks to be included. I would like the freelancer to provide a template tha...
I'm looking for a professional to analyze and compare Excel financial data. Specifically, I need income statements to be analyzed and compared over 1-3 year period in order to make investment decisions. The freelancer should have expertise in Excel, financial data analysis, and be able to deliver results in a timely manner. This is an important project so I'm seeking an experienced individual who can provide high-quality results.I’d like someone who can produce pivot tables, bar graphs and charts and be able to show us the differences if we were to change our pricing model to a new approach compared to what we’re currently doing.
I'm looking for a professional to analyze and compare Excel financial data. Specifically, I need income statements to be analyzed and compared over 1-3 year period in order to make investment decisions. The freelancer should have expertise in Excel, financial data analysis, and be able to deliver results in a timely manner. This is an important project so I'm seeking an experienced individual who can provide high-quality results.I’d like someone who can produce pivot tables, bar graphs and charts and be able to show us the differences if we were to change our pricing model to a new approach compared to what we’re currently doing.
I am looking for someone to help me with sorting a large amount of excel data. The size of the data is more than 1000 rows so it needs to be organized in an efficient way. I already have specific sorting criteria in mind, but I need someone with experience to put everything together and ensure that the sorting is done correctly. The goal of sorting the data is for data entry, so the end result must be properly formatted and properly sorted before it can be entered into a database.