Copy and display a range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have the contents of a named range copied and pasted into a
new location. Ideally the ranges would be on sheet 2, and on sheet 1 there
would be a selection cell. When a range name was selected from a drop-down
list the contents of that range would be retrieved from sheet 2 and displayed
on sheet 1.

Thanks.
 
Hi
if your selection dropdown is in cell A1 you could use (for a single
cell):
=INDIRECT(A1)
 
Yes. I've since worked this out myself using the indirect command (thanks
Debra) to select the range and then copy and paste.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy value in field and insert it into filter 2
Copy & paste macro for multiple worksheets 8
Code to format cells on several worksheets 2
Copying data to the next blank row 0
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
[newbie] copy unhidden cells 1
using named range in VBA 20

Back
Top