Dynamic range based on another column
 

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?

--
Message posted via http://www.officekb.com

Dynamic range based on another column
 

Hi

InsertNameDefine
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

Carrie_Loos via OfficeKB.com wrote:
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?

Dynamic range based on another column
 

Thanks!

Roger Govier wrote:
Hi

InsertNameDefine
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?

--
Message posted via http://www.officekb.com