G
Guest
Hi,
I need to create a pivot table using a long list of data which unfortunately
spills over 65536 rows, therefore I have had to create the data source on two
worksheets. Is someone able to tell me whether I can create a pivot table
using data on two worksheets to combine into one pivot table?
I have tried when selecting the source range to try and select Sheet 1 info
and then select data from Sheet 2 also but it won't let me?
Any ideas?
Thanks,
I need to create a pivot table using a long list of data which unfortunately
spills over 65536 rows, therefore I have had to create the data source on two
worksheets. Is someone able to tell me whether I can create a pivot table
using data on two worksheets to combine into one pivot table?
I have tried when selecting the source range to try and select Sheet 1 info
and then select data from Sheet 2 also but it won't let me?
Any ideas?
Thanks,