Linking worksheets

[Tom Brown]

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

 

[Gord Dibben]

Tom

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

Select A1 and Edit>Paste Special>Paste Link>OK>Esc

Select sheet1 A 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

 

[Tom Brown]

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

 

[Tom Brown]

Gord,

Thank 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

 

[Tom Brown]

Hi Guys,

I am trying to do the same thing again (months later) and now I can't figure
out how to get rid of the ZEROS. I said in this email that I figured out how
to do it before by for the life of me I can't do it now.

I see the box to SKIP blank cells but when I click on PASTE LINK, that box
is no longer available. So, when I link parts of one sheet that has blank
cells, they show up as ZEROS or bogus dates.

Any help appreciated.

Tom

 

[Dave Peterson]

You can hide the 0's in your formula (that you'll have to adjust after using
Paste Link):

=if(sheet1!a1="","",sheet1)

You could hide all the 0's (tools|Options|view tab), but this is too drastic for
me.