VBA Macro - Automating Data Extraction and Printing of Excel Tables
Budget
$30-250
Posted: 1 year ago
Opened
- Description
- Project background:
Our company receives water testing results from an analytical laboratory in the form of an excel spreadsheet. The results are numerical and are split into several different analytes (lead, mercury, etc.).
We present these results in our own formatted tables, both as a table for the results in each instance, as well as a table showing the trend in results. Results are split by the two different water types that we test for, which is recorded in the excel spreadsheet from the laboratory. The project goal is to automate the transfer of the results from the excel spreadsheet provided by the laboratory into our own excel spreadsheet tables and print our formatted tables for delivery to the client.
Examples of the input (laboratory spreadsheet), the current VBA macro and our formatted tables will be provided for development.
Current state of project:
We have built VBA macro which performs the transfer of results into our own per instance and trend tables by copying particular cell locations in the laboratory's excel spreadsheet, although some issues are to be resolved. These are:
The laboratory changes the order of the particular analytes tested (lead, mercury, etc.), making transfer by cell locations erroneous, therefore,
- The macro must be updated to instead search for a particular phrase (lead, mercury, etc.) in the laboratory's excel spreadsheet and copy the result to our tables. This way, if the order of results change from the laboratory, the macros functionality remains.
Where more than one sample is taken, the laboratory will send multiple 'sets' of analytes, therefore,
- The macro must be updated to, when finished searching and copying results as above in (1), check the next column and determine if further analytes are present. If there are, this next set is to be copied to our tables as well.
The copying of several sets of analytes as above in (2) as implemented should place each new set on the next row of the trend table, however, the per instance table will be overwritten, therefore,
- Between each new set of analytes, the macro must print the per instance table prior to being overwritten. Once no more sets of analytes are present, the macro must then print the updated trend table.
Deliverables
VBA Macro which:
consistently copies sets of analytes from the source (laboratory spreadsheet) to the destination (company formatted spreadsheet/tables) correctly by searching for text.
Following being copied, prints the existing company formatted spreadsheet/tables as expected, with tables for each set of analytes copied and one final updated trend table.
- Category
Source: freelancer.com
Add a bid
Similar freelance jobs
I am looking for a freelancer who can assist with Excel data entry. Format/Template: I will provide the format/template for the data. Data Quantity: The project requires entering more than 1000 rows of data. Data Source: The data is sourced from an existing Excel sheet....
1 year ago
$255
Hi Jay P. , I noticed your profile and would like to offer you my project. We can discuss any details over chat....
1 year ago
I am looking for a freelancer who can assist me with data input for a project. The data is in PDF format, and I will need approximately 1-50 entries....
1 year ago
I am looking to set up a Microsoft Office 365 E3 plan and have three questions to answer in order to ensure I get the best service package. I need all of the applications included with this package: Word, Excel, PowerPoint, Outlook, Teams, and OneDrive. I do not have an existing Office 365 account, so......
1 year ago
I am looking for a freelancer who can assist me in creating multiple cells inside a single cell in an Excel sheet. The purpose of this task is to organize data more efficiently. Skills and Experience: - Proficient in Excel and knowledgeable about its features and functions - Experience in working with......
1 year ago
I am looking for a freelancer who can help me gather email addresses and physical contact information (Mobile Numbers) for accounting and finance students in the UK and selected countries in Main Land Europe. Skills and Experience: - Proficiency in data research and collection - Knowledge of accounting......
1 year ago
Hi Neeti K. , I noticed your profile and would like to offer you my project. We can discuss any details over chat....
1 year ago
I need an experienced professional with strong data entry skills to enter alphanumeric data into an Excel spreadsheet. I already have the data provided, and need it inputted into the spreadsheet. The estimated amount of rows of data that need to be entered is 1-100. Accuracy is of utmost importance!......
1 year ago
I am looking to build a stock and options trading system through an excel sheet with real-time data. I am open to suggestions for specific requirements or features to include in the trading system....
1 year ago
I am looking for a freelancer who can help me with my project to convert Word documents to PDF. Here are the details: Files to convert: Word documents Combining multiple documents: Yes, I need to create a single combined PDF file from multiple documents. Additional features: No, I do not need any additional......
1 year ago
I am looking for a skilled statistician to help with our annual report for the current year. The analysis required includes both descriptive and inferential statistics of data collated from satisfaction surveys from home buyers. We have the responsibility of gathering the raw data ourselves, in order......
1 year ago
I am looking to set up a Microsoft Office 365 E3 plan and have three questions to answer in order to ensure I get the best service package. I need all of the applications included with this package: Word, Excel, PowerPoint, Outlook, Teams, and OneDrive. I do not have an existing Office 365 account, so......
1 year ago
Reformating Procedure Manual - The current procedure manual is in Word Document format. - Successful freelancers should include past work and experience in their application. - The project needs to be completed ASAP....
1 year ago
I am looking for a freelancer who can help me collate essential information for our web designer to make content updates to our website. The ideal candidate should have experience in gathering and organizing website content....
1 year ago
I have 2 Anti Money Laundering forms in Word that I have created - about 16 pages long that need to be formatted so they look more professional and then dynamic fields inserted so they populate with name, address, DOB several times in document....
1 year ago
I am looking for an experienced web person who has strong knowledge of websites, registering accounts and creating profiles, taking screenshots, making email accounts and viewing websites and making notes about the process and each step of the process. You need to have strong English skills and be able......
1 year ago
Data Entry Specialist Needed - I am looking for a data entry specialist who can assist me with manual data entry tasks. - The data entry tasks will involve entering less than 100 entries into a specific format. - The ideal candidate should have experience in accurate and efficient manual data entry.......
1 year ago
Hello! I am looking for assistance with a project that involves data entry. Specifically, I need someone to enter images into an existing database, which necessary for the operation of my business. The project scope is limited to 1-100 records that need to be entered. I am aware that this could be a......
1 year ago
I have the full architectural plans of a small hotel and i want the quantities of the basic construction materials that is listed in the attached excel file. Some (like excavations) is difficult to measure exactly so i only need estimation of these quantities. The plans are in Greek language so i'll......
1 year ago
I am looking for a freelancer who can help me merge the content from 200 emails into one Excel spreadsheet. I need the following requirements to be met: - Merge all the content from each email into one spreadsheet - Sort the content according to the sender - Preserve any extra formatting from the emails,......
1 year ago