Dynamic range based on another column

[Carrie_Loos via OfficeKB.com]

I have a worksheet with several columns that I intend to update daily from a
data dump. I am trying to set up a dynamic range based on a previous column
(Column H) that will have a value for every cell within that column. The
column that needs updates (Column O) has blanks and it is those blanks that
will possibly have information in the data dump. I was thinking if I could
give it a dynamic range name then I could look, find and enter the data for
the blank cells. But I am stuck on how to write the dynamic range to equate
to the same number of cells from Column H for Column O. There are several
columns that I will be applying this to but all being the same length as
column H.

Can anyone assist?

 

[Roger Govier]

Hi

Insert>Name>Define
Name RngO
Refers to =$O$1:INDEX($O:$O,COUNTA($H:$H))

or
Name lrow
Refers to =COUNTA($H:$H)

Name RngO
Refers to $O$1:INDEX($O:$O,lrow)

For more information take a look at a tutorial I wrote at
http://www.contextures.com/xlNames03.html

 

[Carrie_Loos via OfficeKB.com]

Thanks!

Hi

Insert>Name>Define
Name RngO
Refers to =$O$1:INDEX($O:$O,COUNTA($H:$H))

or
Name lrow
Refers to =COUNTA($H:$H)

Name RngO
Refers to $O$1:INDEX($O:$O,lrow)

For more information take a look at a tutorial I wrote at
http://www.contextures.com/xlNames03.html
--
Regards
Roger Govier

I have a worksheet with several columns that I intend to update daily from a
data dump. I am trying to set up a dynamic range based on a previous column

[quoted text clipped - 8 lines]

Can anyone assist?