Multiple tables into 1 ever updating table

**Boomer17** · 07-10-2012, 09:10 AM

This is a problem that i have been trying to figure out for weeks:

I was recently tasked with creating a new spreadsheet to compliment the one attached. I need a spreadsheet that combines the three tables all into one list (with no blanks), different colors for each table, and have that new list update when any one of the three original tables are changed. There already is a macro on there (which i cannot change) and multiple other spreadsheets which I had to take off for confidentiality reasons.

Please if anyone could offer any insight on how to achieve this I would greatly appreciate it and am willing to answer any questions to help better explain what i need to accomplish!!!

AD Trial.xls

**arlu1201** · 07-10-2012, 09:29 AM

To take care of the ever-updating part, you can have the macro clear up all data in your master file and then re-copy each individual data set into that master file and re-color it.

Would this work for you?

**Boomer17** · 07-12-2012, 08:58 AM

You mean from the original macro that runs? and also, i need this to be easily transposed on numerous other files like this one

**arlu1201** · 07-12-2012, 09:03 AM

You can add it to the existing macro or have a new one which does it for you.

For the other files, do you want this one macro to do it for all, opening each workbook in turn? Or do you want to trigger the macro to run as and when you open the workbooks?