Forum Discussion
Excel PivotTable
I need help finding the best way to combine worksheets and creating a PivotTable from all the data. Also, every month I get a new report I download and add to this particular workbook but how can I g...
Rujinh -
Take a look at https://www.youtube.com/watch?v=AvVlRJly4X8.
ChrisMendoza thank you for that video, I will take a look at it and see if I can follow along with my workbook. So, will that let me continue to add on to my workbook as it becomes a new months report?
Rujinh - If I recall correctly, this was the first video showing the basic idea and later another video was created on the channel that may address adding new Worksheets. It will be a great starting point for you to learn.
ChrisMendoza okay, perfect. Thank you so much for your suggestion.