Forum Discussion
Copying range of cells referencing named cells with a sequential change
I have a large dashboard with many named cells. I want a summary table of 36 rows and 15 columns to reference the named cell values without having to manually insert each reference.
Example: I enter =A1_A1 into cell D6 and want the adjacent cell D7 to dynamically be =A1_A2 and D8 to be =A1_A3, etc.
Example: I enter =A1_A1 and the next cell down to become =A2_A1. then =A3_A1, etc.
I know there are functions that can address it, I just have not been able find what works. I appreciate any assistance with this. It would save me a tremendous amount of time.
2 Replies
Enter the following formula in D6:
=INDIRECT("A"&ROW(D6)-ROW($D$6)+1&"_A"&COLUMN(D6)-COLUMN($D$6)+1)
Fill to the right, then down or vice versa.
I will give that a try. Thank you so much!!
