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

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

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

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

"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

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





"Tom Brown" wrote in message
...
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

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.



Tom Brown wrote:

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

"Tom Brown" wrote in message
...
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




--

Dave Peterson