Hi Sean,

If I define a name for the first cell in the range, for each range that needs to be dynamic, and use that as the starting point each time, will that work?

I will have a set number of predefined 'Tasks' Name Ranges on the 'Entry' Worksheet, so I can have the same number of starting point named cells in the 'Dataset' Workbook.

What I need to happen is to have the ability to expand or contract the ranges for each replica 'Task_Data' range in the 'Dataset' Workbook. I'm guessing that would be possible if the operations are on the full row each time?

Regarding having the data side by side rather than down the Worksheet, that is not an option for me. I am relying on a program to read my dataset and write it to a SQL Server 2008 R2 database. That program is expecting the data to be defined down the Worksheet (with Project specific information ahead of each 'Task_Data' range of information.

So my thoughts were, if I can name the top right cell in each of my 'Task_Data' ranges and then just copy and past the full set of rows from the dynamic 'Tasks' Named Range in the 'Entry' Worksheet to the starting point cell (e.g. Named 'StartTask1', StartTask2, etc...), then the inserted rows should mover everything below, but the named starting point will move as well.

This assumes that the macro can reference the Defined Name for the starting point cell, which is something I can do with formulas, but am not sure how to do so in the macro code.

Hope his makes sense.

Cheers,

Wayne