Insert Multiple Column Named Range

[chlearning]

Good day.
I have a workbook which contains several named worksheets. On the "Options 10-8-19" worksheet I've created dynamic named ranges for 2 sets of data. I've also established two count cells for the number of rows in range. I'm looking for a way to insert the ranges into another worksheet in the same workbook. The ranges in "Options 10-8-19" start at row $O$3 (to $U$3) and can extend as far down as $O$26, and $O$33 (to $U$33) and can extend as far down as $O$58. I've got the counts in $W3 and $W33, respectively. The dynamic named ranges are Summerrangetest (3-26) and Winterrangetest (33-58). They will be going on worksheets Summers Quotes and Winter Quotes. The rows will need to be inserted starting at B16 (to H16) and down. I've tried to come at this from several directions and can't make it work. Can someone please help? If I can get one to work, I'm sure I can figure out the other. Thanks!

 

[FatBoyClam]

When you say "Dynamic named range", I assume you mean that the range changes size as you enter data.

For example, if there is only 1 row of data, it will represent $O$3:$U$3 (assuming it contains no headers)

If you add a row, it will dynamically change to represent $O$3:$U$4

I'd do this by defining the named range as referring to "=OFFSET('Options 10-8-19'!$O$3,0,0,COUNTA('Options 10-8-19'!$O$3:$O$26),7)" - this has a dynamic number of rows, based on the assumption that column O will have a value in, and you're not interested in the row otherwise, but it has a fixed number of columns (7)