Hi,

Yestesday, I posted this question in the 'Excel Formulas & Functions' Forum, hpoing that someone might have a resolution for my issue using either a Formula or a Function. So far, I haven't got a resolution for this.

So, given that I am open to having macros in my Workbook and I'm a bit pressed for time, I thought I'd pose the same question in this Forum. Perhaps there's a way of updating a 'Named Range' with additional rows in one worksheet from another dynamic Named Range in another Worksheet. My situation is as follows:

I have a range of cells that is 10 columns by 5 rows on an 'Entry' Worksheet where I request input from users of 'Task' information (like a Project Tasks).

My need is for the users to be able to copy any of the rows within that range and then paste additional rows, so that they can add any number of additional Tasks.

I have named the range of 10 columns by 5 rows as 'Tasks' and when I copy and paste in additional rows within that same range, I see that the range in the 'Name Manager' extends to included the additional rows. This is exactly what I need.

However, I now need to write the rows, including any additionally added rows, to a separate 'Dataset' Worksheet for backend processing.

Does anyone know how to replicate a dynamically expanding Named Range to a separate Worksheet?

To be clear, I've attempted to get this working, but so far without success.

I've created a separate Named Range called 'Task_Data' in the 'Dataset' Worksheet of 10 columns by 5 rows. Then I used the technique of selecting that range, entering the formula '=Tasks' and using the [Shift] + [Ctrl] + [Enter] key combination to create an array reference back to the 'Tasks' Name Range in the 'Entry' Worksheet.

This works with the initial Named Range, but as soon as I insert extra rows into the 'Tasks' Named Range, they seem to push the bottom row(s) of Tasks outside of the 'Task_Data' Named Range in the 'Dataset' Worksheet.

Any suggestions on how to get the 'Dataset' Worksheet Named Range of 'Task_Data' to automatically expand to include additional rows that are added to the 'Tasks' Named Range would be most appreciated.

Cheers,

Wayne