Is there a way to copy and paste the cell contents of a named range in another worksheet, by a given cell value. for exaple
Firts of all “RANGE_1” is at sheet 2 (A1:B5) A column is text B column are numbers
In sheet 1 cell a1 contains the text “RANGE_1”
I whant to have a macro triggered by a button that when pressed it gets the range name from cell a1 at sheet 1 then it goes to sheet 2 gets the contents from the existing RANGE_1
an paste all in sheet 1 starting at A3
Is this even possible?
Thank you JohnSUN, it works just like you said, thank you very much. I guess I asked the wrong question. Let see if I explain my self better this time. Range_1 is in sheet 2 - A2:B6, and the B column has some formulas that use sheet 2 - cell B1(the one directly above the second column of the range), what I want to accomplish is to have Range_1 pasted at sheet 1 cell A3 and have the the text in the A column and the B column formulas in the range interact with the cell just above the newly pasted range, so if I paste Range_1 in C45 the formulas will interact with with D44. Like doing a manual copy of A2:B6 and pasting special >> text, formulas and numbers