Dynamic Ranges

[JesusOnEez]

I have a blank template spreadsheet that is copied every time I need to work on some data exports from another system (the data needs to be kept, hence the copying of the original blank template first).

I have set up conditional formatting using;

=MATCH($A1,range,0)

This formula is always in the entire column of row A in Worksheet1 (for the sake of argument)

Problem is in Worksheet2 where the range it's using to compare is always a different number of rows deep...it can be 70, it can be 2000. I always call the range 'interest'.

Is there anyway (in the blank template) of setting column A as a dynamic range called 'interest' so that after data import it automatically sets the range at the desired size?

Are dynamic ranges even possible?

Thanks in advance!

[shg]

Dynamic named ranges are a topic unto themselves. You can start at http://www.cpearson.com/excel/named.htm

[JesusOnEez]

Thanks, that link had just what I wanted.