Pivot Table with data in different sheets
Hi all,
I need to create a pivot table to total all the date I have in 2 different sheets in a workbook (I had to break it down because all the data adds to more than 100K lines). Is there a way to do this? Thanks in advance. |
Pivot Table with data in different sheets
Take a look at this link
http://www.contextures.com/xlPivot08.html I was unable to get the data to work correctly. I was told that it probably will not work well. "Rykar2" wrote: Hi all, I need to create a pivot table to total all the date I have in 2 different sheets in a workbook (I had to break it down because all the data adds to more than 100K lines). Is there a way to do this? Thanks in advance. |
Pivot Table with data in different sheets
Thank you so much ckane, it worked perfectly.
Thanks, I really appreciate it. "ckane" wrote: Take a look at this link http://www.contextures.com/xlPivot08.html I was unable to get the data to work correctly. I was told that it probably will not work well. "Rykar2" wrote: Hi all, I need to create a pivot table to total all the date I have in 2 different sheets in a workbook (I had to break it down because all the data adds to more than 100K lines). Is there a way to do this? Thanks in advance. |
Pivot Table with data in different sheets
Thanks, ckane. I had the same question, and your answer worked!
"Rykar2" wrote: Thank you so much ckane, it worked perfectly. Thanks, I really appreciate it. "ckane" wrote: Take a look at this link http://www.contextures.com/xlPivot08.html I was unable to get the data to work correctly. I was told that it probably will not work well. "Rykar2" wrote: Hi all, I need to create a pivot table to total all the date I have in 2 different sheets in a workbook (I had to break it down because all the data adds to more than 100K lines). Is there a way to do this? Thanks in advance. |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com