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 and from cost 01 to cost 455.
Can someone help me please.
Thanks a lot for any help.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need, maybe just a few of these source sheets and then main Master sheet mocked up manually to show your desired result from those few sample sheets.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
_________________
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!)
Re: How do I merge all tables in one master table?
here it is!
The workbook is devoid any sample data, and mocked up desired results from that sample data.Originally Posted by JBeaucaire
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks