Forum Discussion
VBrants
May 27, 2022Copper Contributor
Easy way to paste named range
Hello! Is there any way to paste named data range from one sheet to other? I want an ability to fulfill sheet by typical blocks of data (including many columns and rows) but i failed to find any sollution.. Does anyone know how to make it possible?
Thanks in advance!
1 Reply
Sort By
- mtarlerSilver Contributor
VBrants you can just enter =name to show the data on the other sheet. but I'm guess you want to know how to easily select the named range? You can use the Find&Select - Go To.. item:
which brings up
just select the named range and it will take you there and it will be selected. Copy and paste.
Another 'trick' that may or may not be relevant is that if you are trying to copy the same data to the same location on multiple sheets you can highlight multiple sheets (shift or ctrl click the sheet names) and then when you paste you will paste onto ALL of the selected sheets (be WARNED to make sure you really want it on all those sheets)