Hi
I have a number of files (50) in a given location and all have the same template but colleagues complete information in them at the end of each month. I would like a macro that can extract say cells A1 and D9 and populate them in an open file.
Can someone give me a steer on some VBA?
Thanks
Easier (and quicker) to use Power Query (Get & Transform Data).
Attach a sample workbook showing the structure of your source file(s) and another showing your required output.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thanks Olly. Have not heard of Power Query. Happy to try anything!
To be honest, haven't got anything to share in terms of a file. For now, think a blank spreadsheet (which is what it's likely to be) and all i want to do is point at various files and extract certain cells. Sorry if that sounds vague!
Okay - hard to give specific advice / solutions, without a requirement.
Your starter for 10, though - this query will combine data from all Excel files in a folder:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks