I have 300 excel files each with the exact same format - 4 worksheets in each file with same column/row headers. I am trying to extract information from select cells of each of these 4 worksheets (for example, from cell D26 in worksheet A, from cell D62 in worksheet B, etc) from all 300 excel files and put that data into a new master excel file that contains the information from each of the 300 excel files. Is this possible?

  • 1
    Yes. Yes it will be easier if you can elaborate on what programming language you can use. VBA, WSH, powershell ... or do not care how. – STTR Dec 2 '13 at 10:01

There is some really nice code posted here that should do what you want with a few tweaks.


Some changes will need to be made which is nicely commented. These rows get all the data from column A in the workbook and copy it to the master sheet.

LR = Range("A" & Rows.Count).End(xlUp).Row  'Find last row
Range("A1:A" & LR).EntireRow.Copy .Range("A" & NR)

Instead you will need to loop through the worksheets and set the ranges you want copy with something like this.

wbData.sheets(1).range("A2:A26").copy .Range("A" & NR)
NR = .Range("A" & .Rows.Count).End(xlUp).Row + 1
wbData.sheets(2).range("A2:A62").copy .Range("A" & NR)
NR = .Range("A" & .Rows.Count).End(xlUp).Row + 1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.