Reference web query data in seperate worksheet

A

AmyLRuck

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?
 
G

Gord Dibben

Select the data range in sheet1.

Switch to sheet 2 and select A1 and Paste Special>Paste Link>OK>Esc.

When sheet1 updates, so shall sheet2.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Seperate worksheets 1
matching & combining data from seperate worksheets 2
Reference cells in seperate worksheet 3
Data validation against seperate worksheet 1
help with Linking excel 1
Auto Populating & Name Recognition between Worksheets 1
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Worksheet relative reference 3

Top