I have range names for various range on sheet1 for eg BR1, BR2 etc that will be the same as the sheet name
I need code that will copy the data from the applicable range name to the appropriate sheet using paste Special (using Paste link if possible)
The comments , cells values and fill color must update as soon as the items in sheet1 is changed
Your assistance in this regard is most appreciated
I need code that will copy the data from the applicable range name to the appropriate sheet using paste Special (using Paste link if possible)
The comments , cells values and fill color must update as soon as the items in sheet1 is changed
Your assistance in this regard is most appreciated
