I want to combine 3 workbooks from a single folder into one workbook with same column headers.
Example:
Sheet1, Sheet2, Sheet3 should combine into sheet4.
I want to combine 3 workbooks from a single folder into one workbook with same column headers.
Example:
Sheet1, Sheet2, Sheet3 should combine into sheet4.
see Range.Copy method in VBA inner help …
This is very straightforward with Power Query (Get & Transform Data).
Something like:
Please Login or Register to view this content.
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...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks