Gord,

Thanks you so much. It worked perfectly. I even managed to figure out how
to get rid of all the blank zeros and dates.

Thanks again,

Tom

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Tom

Select sheet1 A:H used range and switch to sheet2.

Select A1 and EditPaste SpecialPaste LinkOKEsc

Select sheet1 A:D used range and I:K then switch to sheet3 and paste link
there.

Don't select entire columns or you will create a monster workbook.


Gord Dibben MS Excel MVP

On Thu, 14 Jun 2007 12:38:22 -0600, "Tom Brown" wrote:

I think I am trying to do something that is simple, but have not been able
to get it done.

My wife has master spreadsheet with lots of columns and rows where she
enters data. I have added two more worksheets on the same workbook and
given them individual names. So, her spreadsheet has three tabs at the
bottom, each with a unique name.

I would like for the second tab to display the data in columns A thru H on
the first tab. The third tab would display the data in A thru D from the
first tab and also I thru K. Basically she wants to look at different
data
sets (views) from the Master list. She only wants to enter and modify
data
on the first tab (worksheet) but view and print subsets of that data on
the
other tabs (worksheets).

I have been unable to link the different parts of the spreadsheet. I know
it's something simple I am doing wrong. Any help appreciated.

Tom