Home Creating a summary sheet from multiple workbooks
Reply: 0

Creating a summary sheet from multiple workbooks

user781
1#
user781 Published in April 25, 2018, 8:40 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

.Range ("G4", "H4", "G8", "H8", "G10", "H10", "G17", "H17")

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?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.327599 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO