can only figure out how to do this one cell at a time

In A1 of Sheet2 enter =IF(Sheet1!A1="","",Sheet1!A1)

Simply drag/copy across and down.

Adjust cell references to suit your needs.


Gord Dibben MS Excel MVP

On Tue, 16 Jun 2009 11:12:01 -0700, Dan
wrote:

I did work but it also put zeros in the blank cells

"Bernie Deitrick" wrote:

Dan,

You can create links to multiple cells by first selecting all the cells that you want to link. In
the formula bar, type = and then navigate to the first cell that you want to link to and select it.
(If the address comes up with $, press F4 until the $s go away) and then press Ctrl-Enter.

HTH,
Bernie
MS Excel MVP


"Dan" wrote in message
...
Hi,
I am trying to link rows and column from one worksheet to another. So far I
can only figure out how to do this one cell at a time and when I highlight
the whole area that I want to link it just links the first cell in that row
or column. I have a lot of data so doing this individually is not practical.
Can anyone help me?