Hi,
When I run a perticula report in our company system it down loads all data into one workbook but splits different departments in each worksheet, so I have 40 worksheets all with a different amount of lines but all the same data format.
I want to put this information into a pivot table so I can review the information but currently have to copy info from each sheet. Can anyone work out a quicker way to copy this information over
The head starts from A1 - N1
Thanks
Neal
Bookmarks