Naming a dynamic range

Hi,

I have two spreadsheets that I need to define as named ranges.
they are both dynamic (based on queries) and the first one is a single column (column A)

the second worksheet has two columns A:B

how can I name each oen dynamically?

thanks in advance,
Matt

You can name them with a combination of the offset function and other functions eg match, min, max etc

Regards

Dav

Originally Posted by matpj

Hi,

I have two spreadsheets that I need to define as named ranges.
they are both dynamic (based on queries) and the first one is a single column (column A)

the second worksheet has two columns A:B

how can I name each oen dynamically?

thanks in advance,
Matt

Using a Worksheet_Calculate trigger, you could locate the last non-blank A cell with something like

Please Login or Register  to view this content.

and then extend the range of your (pre-existing) named range with soomething like

Please Login or Register  to view this content.

Does this help?
---