Forum Discussion
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 soll...
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)