Completed

Excel VBA Macro project - Macro to generate a report from data in multiple files

Hello,

This is a Excel VBA macro project to create a macro that pulls information from multiple sheets into one report.

The macro needs to gather data from a number of different uniform spreadsheets (same template) into one complete sheet. Each individual Excel spreadsheet is for a different project and all relevant data in each template will be stored on row 2 on a tab called “ExportData”. The location of the files will change (i.e. different people will be running the Report Macro) but the project spreadsheets will always be in the same folder as the Report Macro Excel file.

I need a macro that will:

-Be stored in an Excel file called Report.

-It needs to copy line 2 on “ExportData” tab from every Excel file that is in the same folder as the Report Excel file. Note that line 2 column count is not yet known so it should pull the whole row.

-Needs to pull all of these rows into the Report Excel beginning on line 2 (line 1 will be the description of what each column is).

-Needs to confirm it is finished and how many files it pulled.

-Needs to provide pop up warning if an Excel file does not have “ExportData” tab or similar pull error, but be able to continue once you acknowledge the error.

-Needs to first clear all of the data on the Report sheet except for the row 1 descriptions (i.e. resets every time it is run).

-The Report sheet needs two buttons – One being “Run Report” to run the macro, and a second button called “Clear” to remove all report data.

-Needs to have notes describing what parts of the code do.

-Needs to be unlocked, not password protected.

Note – If you can also make a second version of the macro that only pulls information from new files added since the macro was last run - instead of deleting and re-adding everything from scratch - this would be very helpful. There are cases where a few additional reports might be added after an initial run. If you can do this please note in your response.

Thank you.

Skills: Excel, Visual Basic, Visual Basic for Apps, Data Processing

See more: excel vba project 2007, vba code generate report excel, updating excel vba workbooks without changing data, excel vba project plan, excel vba project search engine, fun excel vba project, finalize excel vba project, excel vba staff leave report date leave type, excel vba build format report, 1st excel vba project, excel vba project schedule, excel vba project description, online excel vba project india, excel vba create expense report, automatically import data multiple files excel, excel vba tutorial generate report, sample excel vba project, excel vba project data

About the Employer:
( 0 reviews ) Calgary, Canada

Project ID: #24048784

Awarded to:

paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will pull data from several workbooks and will log changes. I More

$160 CAD in 5 days
(252 Reviews)
7.5

36 freelancers are bidding on average $146 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

$250 CAD in 3 days
(762 Reviews)
8.5
schoudhary1553

Hello, I can help you with your project - Excel VBA Macro project - Macro to generate a report from data in multiple files I have gone through your job posting and become very much interested to work with you. I am More

$240 CAD in 5 days
(358 Reviews)
8.0
P0L

Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$200 CAD in 2 days
(355 Reviews)
7.5
dgled

Hi, I am an expert and guru in Financial, Math and Microsoft Office/Excel/VBA/Macro. I have considerable experience in merging files and manipulating the data in a structured database. , especially with exporting datab More

$200 CAD in 5 days
(90 Reviews)
7.1
nagyzoltan68

Hello, I would like to work on your project. I have a great experience using excel macros / VBA, data formatting and data manipulation in excel, working with multiple files, transferring data with/without changing the More

$125 CAD in 2 days
(128 Reviews)
6.5
VladimirLilenko

Hello! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko? More

$140 CAD in 1 day
(135 Reviews)
6.5
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$100 CAD in 2 days
(144 Reviews)
6.2
fatimatuzzohura

Dear sir/madam, I have done several projects on data mining, visualization, data scrapping, and then produced cohor analysis, dashboards, market segmentation, linear discriminant analysis etc. Over the years , my work More

$200 CAD in 7 days
(148 Reviews)
6.3
finecodervw

Hi, Keen to work on this project. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It More

$90 CAD in 5 days
(91 Reviews)
5.9
gayuh

Hello, I propose the Report file to have two sheets: "Control" and "Report". The "Control" sheet is where the buttons "Run Report" and "Clear" will be located. The "Report" sheet is solely for storing the data, with ro More

$115 CAD in 7 days
(102 Reviews)
6.1
AnowarRatul

$ 49 CAD only ------ In just 5 Hours ------ I can build your VBA Macro Program to pull data from different files absolutely as you described, I have done this type of project before. ------- Excel VBA Macro Coding, For More

$49 CAD in 1 day
(87 Reviews)
5.1
ravinderkumar248

Hi Good Day, I can do this immediate after you accept my bid I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and [login to view URL] give me this o More

$120 CAD in 2 days
(21 Reviews)
4.6
IgeS

Hi there, Need to have a macro that will populate data from "ExportData" tab of raw files into the Report File? Aside from the requirements mentioned in the job post of what the Macro should do or have, for the auto More

$120 CAD in 2 days
(16 Reviews)
4.6
urmate

Hi there I am a senior software engineer with 10 years of practical programming experience. I have excellent programming and development skills in various programming languages and frameworks. I am interested in your More

$250 CAD in 7 days
(30 Reviews)
4.3
arash18k

Hi, I can write this script in VBA for you, also the location of files can be changing by user. I will add a setting tab in your report Excel, in this setting you can modify the location of each Excel file that needs t More

$250 CAD in 3 days
(12 Reviews)
4.4
reubengi

Hi there, I have good VBA experience and can write you the macro for both the conditions you have mentioned. Warm regards Reuben

$80 CAD in 2 days
(9 Reviews)
3.9
dhanrajkarthick

Hi there, I am a Microsoft Certified Professional in Excel & VBA as an Expert. Have deep knowledge to handle large number of data in Multiple Excel files. Good and Deep understanding in gathering requirements. Will d More

$100 CAD in 1 day
(9 Reviews)
3.6
zemanielmustapha

Hello i m laureat of high School of ingeneer with long expérience in the field, I can do this work, and i can do the seconde version.

$111 CAD in 3 days
(3 Reviews)
3.4
chomsengdev

Hello. I am really interested in your project. I have enough experience on python, C/C++, C#, java,VBA,Excel I am 100% sure i can satisfy your requirements perfectly. User-Friendly Interface And Clear Algorithm Will En More

$300 CAD in 7 days
(1 Review)
2.7
renato0216

Hello! i can make excel macro that can generate report from multiple datas I'm expert in VisualBasic for application, MS office VBA. If you are interesting my bid , please tell me your office version and detail datas More

$100 CAD in 3 days
(0 Reviews)
0.0