| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Across Multiple Sheets of Data | Excel Discussion (Misc queries) | |||
| Excel 2007: Create a pivot table where data is in multible sheets | Excel Worksheet Functions | |||
| Pivot table for multiple sheets | Excel Discussion (Misc queries) | |||
| How do i create pivot table from 2 sheets. | Excel Discussion (Misc queries) | |||
| pivot table to sheets | Excel Worksheet Functions | |||
Linear Mode
