| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting data for pivot table from another spreadsheet
I want to create a pivot table in spreadsheet A based on data in a
named range in Spreadsheet B (Spreadsheet B has mulitple tabs) . So far I have had not luck trying any of the 3 options presented to me to get data. Can some give me some pointers or tell me it is not possilbe. Thanks JDB |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting data for pivot table from another spreadsheet
It's possible. There can be two ways
1. Create pivot table in spreadsheet B and copy pivot table to spreadsheet A. Or 2. Create pivot table directly to spreadsheet A and give source to spreadsheet B. "JDB" wrote: I want to create a pivot table in spreadsheet A based on data in a named range in Spreadsheet B (Spreadsheet B has mulitple tabs) . So far I have had not luck trying any of the 3 options presented to me to get data. Can some give me some pointers or tell me it is not possilbe. Thanks JDB |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting data for pivot table from another spreadsheet
Option1 worked perfectly. thanks VERY much.
This is a big, big help. JDB - 4 20 S, 170 00 W AmSamoa On Apr 22, 4:40 pm, Himani wrote: It's possible. There can be two ways 1. Create pivot table in spreadsheet B and copy pivot table to spreadsheet A. Or 2. Create pivot table directly to spreadsheet A and give source to spreadsheet B. "JDB" wrote: I want to create a pivot table in spreadsheet A based on data in a named range in Spreadsheet B (Spreadsheet B has mulitple tabs) . So far I have had not luck trying any of the 3 options presented to me to get data. Can some give me some pointers or tell me it is not possilbe. Thanks JDB- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting data for pivot table from another spreadsheet
Thats great !! Could you please mark it as answered? Thanks !!
"JDB" wrote: Option1 worked perfectly. thanks VERY much. This is a big, big help. JDB - 4 20 S, 170 00 W AmSamoa On Apr 22, 4:40 pm, Himani wrote: It's possible. There can be two ways 1. Create pivot table in spreadsheet B and copy pivot table to spreadsheet A. Or 2. Create pivot table directly to spreadsheet A and give source to spreadsheet B. "JDB" wrote: I want to create a pivot table in spreadsheet A based on data in a named range in Spreadsheet B (Spreadsheet B has mulitple tabs) . So far I have had not luck trying any of the 3 options presented to me to get data. Can some give me some pointers or tell me it is not possilbe. Thanks JDB- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA READING DATA FROM PIVOT TABLE TO SPREADSHEET | Excel Worksheet Functions | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| Dynamically generating a spreadsheet with custom pivot table including data | Excel Programming | |||
| Pivot table in Xml Spreadsheet | Excel Programming | |||
| Pivot table, data from various spreadsheet | Excel Discussion (Misc queries) | |||
![JDB[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
