|I don't know that it can be done as simply as just entering =Tile1. |
I know it can to be done via VBA or by using the INDEX function, but the INDEX method would require an INDEX function in each cell.
In other words,
=INDEX(Tile1,1,1) would return the upper left cell of the named range
=INDEX(Tile1,2,1) would return the cell just below the upper left cell
There are creative ways to avoid entering each individual INDEX function by using the ROW() and COLUMN() functions, but we would need more detail related to the location of the Named range and the destination range for the "copy". Using ROW() and COLUMN() as the arguments for the INDEX Function might allow for simply dragging a single INDEX function across and down.
VBA would be easy:
Select the first cell of the destination range and run this code:
There may be a way to make the VBA solution automatic but I need to know if you are even interested in a VBA solution.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03