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?