Linking Blank Cells Without a "0"

[Julia Ouellette]

 

[Julia Ouellette]

Sorry about that....here's my question:

I am trying to link many cells in one worksheet to
another. The cells in Worksheet 1 are currently blank.
Once they are filled I want the cells in Worksheet 2 to
have the same values. But as long as the ones in
Wksht 1 are blank, I want the ones in Wksht 2 to also
be blank. Right now they are all showing as 0. Is there
an easy way to have those links show as blank if the
source cell is blank? I'm guessing I could do it with an
if/then function, but I think that will take forever for me
to put in each cell.

Another related question --- the flow of cells in Wksht 1
is left to right. The cells in Wksht 2 are up and down
(same values, just in Wksht 1 the column headers are
the row headers in Wksht 2). Is there any way to easily
link those cells? I know copying and pasting won't
work -- is there any easier way than just linking each
cell individually? (i've got many cells to link)

Thanks in advance for any assistance,


Julia Ouellette

 

[JON JON]

Try Tools>Options>View, Uncheck "Zero Values". Your sheet will not
display "0" but it is still there.

 

[Alan Cocks]

Julia
Select all the cells on the first sheet
copy
Paste special Make sure "Transpose is selected"
Alan

 

[Julia Ouellette]

That's great - but when I choose Transpose, the option
to "Paste Link" is greyed out. Is there any way to do
both? (Transpose and paste link?)

Thanks!

Julia

 

[Peo Sjoblom]

You could use a formula if you want to link them,
Assume you have values in A1:a20 in sheet1 and you want
them transposed to A1:T1 in sheet2, in the name box above
the row headers type in A1:T1 and press enter, now in the
formula bar put

=TRANSPOSE(Sheet1!A1:A20)

then enter the formula in all cells with ctrl + shift & enter

that would transpose the values but also link to sheet1 so
if you change the value in A10 in sheet1 it will change in J1 in sheet2

 

[Julia Ouellette]

Just wanted to thank those who posted suggestions
for me! All came to good use, and worked perfectly! I
appreciate the time taken to help those of us who
aren't as fluent in Excel.

Thanks again,


Julia