VBA code for Excel 2010
- or -
Post a project like this2517
$75
- Posted:
- Proposals: 15
- Remote
- #1560759
- Awarded
917239234163549550666143588352760486495494560636651101762911745921228050
Description
Experience Level: Intermediate
General information for the business: Sorting data on old spreadsheets
Industry: Sports and Fitness
Description of excel work: I have a folder with 200+ randomly named excel 2010 workbooks. Each workbook consists of one spreadsheet. I need VBA code on a master spreadsheet to look at all the workbooks/spreadsheets in the folder and consolidate specific data contained on these many spreadsheets into one master spreadsheet. In column A of the master spreadsheet I would like the value from cell A1 on each of the unique spreadsheets copied into column A for as many row as there are unique spreadsheets.
Also from each of the 200+ spreadsheets in the folder, find the maximum date in column F and return the values in columns H and K from that row with the maximum date to columns B and C on the master spreadsheet. I included a sample individual spreadsheet and a sample master.
Extra notes:
Industry: Sports and Fitness
Description of excel work: I have a folder with 200+ randomly named excel 2010 workbooks. Each workbook consists of one spreadsheet. I need VBA code on a master spreadsheet to look at all the workbooks/spreadsheets in the folder and consolidate specific data contained on these many spreadsheets into one master spreadsheet. In column A of the master spreadsheet I would like the value from cell A1 on each of the unique spreadsheets copied into column A for as many row as there are unique spreadsheets.
Also from each of the 200+ spreadsheets in the folder, find the maximum date in column F and return the values in columns H and K from that row with the maximum date to columns B and C on the master spreadsheet. I included a sample individual spreadsheet and a sample master.
Extra notes:
William C.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
9 May 2017
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies