See reply to your first post.

Best to stick with the same thread to save time and effort of responders.


Gord Dibben MS Excel MVP

On Wed, 16 Jul 2008 00:03:51 -0700, LindaSP
wrote:

I have a worksheet with information that I want to copy automatically into
columns on another worksheet. How do I do this? I got the formula that
someone gave out a couple of years ago:

=IF(Sheet1!A3<"",Sheet1!A3,"")

But I don't know how to use it. When I put this formula into the cell where
I want the copying to start, nothing happens, except the cell shows a green
upper left corner and the following appears in the cell: # REF !

Does Sheet1 have to equal the name I've actually given to my sheet (I've
changed the name of the original worksheet on the tab at the bottom)?

Can I start the copying of data on row 3 or do I have to start with row 1?