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 ente...
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!!
