J
John
I am working on a workbook with several worksheets. One one of the
worksheets, I run a bunch of scenarios. In each scenario, there are a
bunch of calculations which produce a final total column (1 column
wide, 20 rows deep). There are many different scenarios on this
sheet, so I have many instances of these 1x20 "blocks" (all of them
are different and each "block" represents a different scenario.
On another worksheet in my workbook, I am trying to reference these
1x20 "blocks" in a manner where I dont have to copy and paste them
each time I need them to occur. I was wondering if there was a way to
name each of the 20 cell ranges, and then on the next worksheet,
click the cell which I want to be the top of the pasted range, and
then reference the named range so excel will automatically fill in all
20 descending cells (from the original range) on that second
worksheet..
Maybe there is another way to do this that I am completely unaware of.
Hopefully I explained this clear enough so someone will be able to
help.
Thank You
worksheets, I run a bunch of scenarios. In each scenario, there are a
bunch of calculations which produce a final total column (1 column
wide, 20 rows deep). There are many different scenarios on this
sheet, so I have many instances of these 1x20 "blocks" (all of them
are different and each "block" represents a different scenario.
On another worksheet in my workbook, I am trying to reference these
1x20 "blocks" in a manner where I dont have to copy and paste them
each time I need them to occur. I was wondering if there was a way to
name each of the 20 cell ranges, and then on the next worksheet,
click the cell which I want to be the top of the pasted range, and
then reference the named range so excel will automatically fill in all
20 descending cells (from the original range) on that second
worksheet..
Maybe there is another way to do this that I am completely unaware of.
Hopefully I explained this clear enough so someone will be able to
help.
Thank You