PDA

View Full Version : Combining Data from Multiple Tables & Refreshable



bud2430
07-14-2015, 03:51 PM
I have several worksheets (11) all in the same workbook that get updated with bank data and I'm trying to figure out how to combine certain columns of the data from each worksheet (columns M:R) into one master worksheet (in the same workbook). I have all the data in tables.

I would also like it so it can be updated or refreshed daily. So each day when the bank data is updated, I can run the macro and it will push the new data to the master worksheet.

Any help or guidance is appreciated.

bud2430
07-15-2015, 09:13 AM
I've attached a sample of the worksheets I'm working with.