Merging multiple tables into one master table using macro
Hi there! I need to combine all tables in 1 summary sheet/table within the same workbook. There are 2 tables in each sheet named: "ingredtable" and "cost".
example: Need to summarize all info from ingredtable01 to ingredtable455
Can someone help me please.
Thanks a lot for any help.
Are the table layouts the same?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
yes, tables are in the same position in every single sheet and have the same headings
could you attach a sample file with these tables (non-private data please)?
Here it is:
Thank you, I'll download the file and see what I can do for you, If I have any questions I'll post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks