evenflow357
New Member
- Joined
- Sep 13, 2012
- Messages
- 8
For my job I get sent large spread sheets with about 35,000 raws of data. Each spread sheet is the same layout and column headings.
I have been putting the data into the same spread sheet and using a pivot table to extract the data I need (that is from the overall data and not just one spread sheet). But this spread sheet where I have been getting the data is getting to large. So ideally is there a way I can insert data from different spread sheets into a pivot table? I looked into this and can link data from different tabs or sheets. But not different spread sheets/work books.
I would say I have good to advanced excel skills. I don't know VBA, but can edit the code if given instructions.
Thanks
I have been putting the data into the same spread sheet and using a pivot table to extract the data I need (that is from the overall data and not just one spread sheet). But this spread sheet where I have been getting the data is getting to large. So ideally is there a way I can insert data from different spread sheets into a pivot table? I looked into this and can link data from different tabs or sheets. But not different spread sheets/work books.
I would say I have good to advanced excel skills. I don't know VBA, but can edit the code if given instructions.
Thanks