user5883 Published in September 19, 2018, 11:03 am
I have a task at hand. I want to create a summary sheet by extracting data from multiple workbooks in a folder. These files are same in formatting. What i need to do is extract data from each workbook from the 5th worksheet. The cells are G4, H4, G8, H8, G10, H10, G17, H17. I found a code at microsoft.com.
The code works fine when i provide only one cell like G4 or G4 and H4. The moment I provide the sourcerange as
the code misbehaves. I get multiple rows for a single entry etc etc. I am not able to understand how to provide this sourcerange so that I get G4, H4, G8, H8, G10, H10, G17, H17 all in one single row inn the sourcerange variable. Any suggestions?
excel vba excel-vba
share|improve this question
edited Nov 28 '13 at 14:40
asked Nov 28 '13 at 14:17
closed as off-topic by pnuts, chris neilsen, user2140173, psubsee2003, Toto Mar 6 '14 at 8:54
This question appears to be off-topic. The users who voted to close gave this specific reason:
"Questions asking for code must demonstrate a minimal understanding of the problem being solved. Include attempted solutions, why they didn't work, and the expected results. See also: Stack Overflow question checklist" – chris neilsen, Community
If this question can be reworded to fit the rules in the help center, please edit the question.