chlearning
New Member
- Joined
- Dec 13, 2019
- Messages
- 11
- Office Version
- 2019
- Platform
- Windows
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!
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!