match column length

  • Thread starter Thread starter Andy M
  • Start date Start date
A

Andy M

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?
 
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.
 
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
 
Back
Top