match column length

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy M - 04 Mar 2008 21:07 GMT

This is something which I'm sure I found the answer to before, but
have now forgotten!
If I have a column of data on worksheet1, and it can cover an unknown
number of rows. I want to mirror it on worksheet 2. I could just
create a very long column of cell references on worksheet2, but I seem
to remember some trick to avoid having a longer list on worksheet 2
than on worksheet 1. Can anyone help me?

Reply to this Message

Gary''s Student - 04 Mar 2008 22:01 GMT

Instead of using a formula like:
=Sheet1!A1
in you cells in Sheet2, use:
=IF(Sheet1!A1="","",Sheet1!A1)

and copy way down. Don't worry about the extra cells you are using. The
advantage of this method is that as you add or remove data from Sheet1, Shet2
will automatically track.

Signature

Gary''s Student - gsnu2007e

> This is something which I'm sure I found the answer to before, but
> have now forgotten!
[quoted text clipped - 3 lines]
> to remember some trick to avoid having a longer list on worksheet 2
> than on worksheet 1. Can anyone help me?

Reply to this Message

Henn Sarv - 05 Mar 2008 10:29 GMT

Be carefully with that

the "" is absolutely other thing as blank cell

For example, when You try to =counta(somerange) You get different result
when You have blanks or when you have "calculated blanks"

Henn

> Instead of using a formula like:
> =Sheet1!A1
[quoted text clipped - 13 lines]
>> to remember some trick to avoid having a longer list on worksheet 2
>> than on worksheet 1. Can anyone help me?

Reply to this Message

Rate this thread: