On Friday, July 25, 2014 6:08:10 AM UTC-7, GS wrote:


I don't understand why you're listing the dynamic range names in colA!


Hi Garry,

What is going to column A is a copy of the named ranges data after the user makes changes to those ranges.

The actual named ranges are off screen. By using two DV drop downs and some code, data is move FROM one range TO another, then reposted into column A and sheet 2 column A. So far it is working mostly as it needs to. Not to say that improvements could be made, but for me to throw all the weight of your suggestions into this would be pointless as it is far above my pay grade.

Some error checking would most likely make good sense.

Here is a link if you care to take a look, plus there is a link on the sheet to the original thread, I suppose it will work from a linked workbook.


https://www.dropbox.com/s/fe2w5jouk0...rop%20Box.xlsm


Howard