Combining data from several sheets into a master sheet
Hi
I pull off monthly performance report from one of ours systems.
I need to create pivot table showing some of the KPIs in these reports.
The best way I can think of doing this is to pull each month's data into a new worksheet in my workbook and giving the tab a relevant name.
To get the pivot table to work I need all the data in 1 sheet/table.
I would like to click a button after pasting in data into a new worksheet that would automatically add the new data to the end of the "master" worksheet and update the pivot data range to include it.
Can this be done?
RE: Combining data from several sheets into a master sheet
Hi Richard,
Thank you for the forum question.
Everything is possible in Excel (almost).
You can write a Union Query in SQL in MS Query or you can write a macro in the Visual Basic Editor.
I do not know how much knowledge you have of Excel, but you will need to code in SQL or VBA.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
