LinkBack URL
About LinkBacks
Hello,
Is there a good way to merge multiple tables?
If I have 4 tables, on 4 different sheets.
Is the only option to copy the ranges of each table and paste on a new merge table?
Or is there a better way?
thanks
Hello,
Is there a good way to merge multiple tables?
If I have 4 tables, on 4 different sheets.
Is the only option to copy the ranges of each table and paste on a new merge table?
Or is there a better way?
thanks
That sounds like the best option, and is something you can do quickly.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
If you have Access, you could import all the tables to Access, run a Union All Query and then export the results back to Excel. It would take depending on the size of the tables only a few minutes.
Alan
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks