Reference web query data in seperate worksheet

  • Thread starter Thread starter AmyLRuck
  • Start date Start date
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?
 
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
 
Back
Top