Forum Discussion

VBrants's avatar
VBrants
Copper Contributor
May 27, 2022

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!

BI & Data Analysis
excel
Formulas and Functions
Macros and VBA

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    May 27, 2022

    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)

     

     

Resources