I have a Master sheet in my workbook and I have 7 other sheets named 'One', 'Two' etc etc up to 'Seven'.
I need a macro that begins in 'One' and copies A2:Ox (where X is the last used row of data) and pastes VALUES below the last used row of data in the Master sheet. It then does this for sheet Two, Three etc.
Any help would be much appreciated.
Try this code...
Please Login or Register to view this content.
Last edited by RudiS; 03-30-2014 at 10:24 AM.
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 also various other sheets in my workbook, so the codes above will not work on the specified sheets.
So change to:
Please Login or Register to view this content.
Brilliant. Thanks Olly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks