| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference web query data in seperate worksheet
I have pulled information into a worksheet through a web query and I am
trying to create a new worksheet with the same information that will also be updated when I open the workbook. I want to have them on seperate worksheets so I can format the 'final' data set. Does anyone have any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reference web query data in seperate worksheet
Select the data range in sheet1.
Switch to sheet 2 and select A1 and Paste SpecialPaste LinkOKEsc. When sheet1 updates, so shall sheet2. Gord Dibben MS Excel MVP On Sat, 4 Oct 2008 08:22:01 -0700, AmyLRuck wrote: I have pulled information into a worksheet through a web query and I am trying to create a new worksheet with the same information that will also be updated when I open the workbook. I want to have them on seperate worksheets so I can format the 'final' data set. Does anyone have any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data in a seperate worksheet | Excel Discussion (Misc queries) | |||
| How do I change the Row Reference from a seperate worksheet. | Excel Discussion (Misc queries) | |||
| Auto filling data according to seperate worksheet | Excel Discussion (Misc queries) | |||
| Query to Return Value from Seperate Worksheet | Excel Discussion (Misc queries) | |||
| viewing seperate data within worksheet | Excel Worksheet Functions | |||
Linear Mode
