Inserting a range of cells

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

Guest

This is a bit hard to explain but I have a selection of ranges which I need
to be able to choose from and paste into another workbook.
For example, option 1 could have formulas or values in rows 1 to 4
options 2 might have a different formulas or values in 6 rows.
I want to be able to click in any cell in the new workbook and choose which
option I want and have those values copied over.
Sorry it's not very clear but I'm not sure how else to explain it. Any
advice from anyone who understands me???!!!
 
Look at the online help for INDIRECT, it might suit your needs.
Examples:

=INDIRECT("E"&H1)
=INDIRECT(ADDRESS(H1,5))

If H1 contains the number 1 then both formulas will locate the cell
E1.

HTH
Kostis Vezerides
 
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

How do I have a cell value define a dynamic named range? 15
Excel VBA 1
a data validation list that contains a list of named ranges - not alist from a named range 1
CountIf previous cell formula 0
Trying to find additional ranges outside of min, max, and average 2
VBA set thick borders around non empty cells in range 0
Finding location (or start cell) of highest consecutive values 3
Use Text and Cell vale to reference a named range inside a formula 1

Back
Top