Hi guys,

I basically have lots of data that I would like in a pivot table and chart. However, there is so much of it, that there are not enough rows on the spreadsheet. So I have had to put the data across two spreadsheets.

Is there anyway I can have a pivot table with all the data in it?

(the second spreadsheet is basically continuing where the other left off because it's time based- financial period, category,spend)

Thanks