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