i have multiple sheets containing a table each which I want to merge to form a master table sheet. Also I need this master sheet to be updated automatically incase we make any changes to the tables forming this master sheet. I have been searching for 5 days but no success so far. I also got MS Office 2013 and tried with the Power Pivot etc. Its actually useless. So now, I am ready for any inputs from the experts here who can help me with this issue. I dont want to copy paste the data to create a master sheet because we update the data daily and the rows increase every minute. I mean the data entry team here keeps feeding the data in. Also downloaded your pdf formula sheet. Please help.
Merging Tables to Form a Master Table - Auto Update
- Thread starter Rajeev
- Start date
bobhc
Excel Ninja
jeffreyweir
Active Member
Here's another approach I did recently:
http://www.excelguru.ca/forums/showthread.php?1823-Excel-Sheet-Setup-(Advance)&p=8784#post8784
http://www.excelguru.ca/forums/showthread.php?1823-Excel-Sheet-Setup-(Advance)&p=8784#post8784