Forum Discussion
progessing sheets in columns
Hello,
I am attempting to fill a column with the following formula, with the sheet name progressing by 1 each time. ='G1'!$K$24 in cell 1, ='G2'!$K$24 in cell 2, ='G3'!$K$24 etc.. However it does not work to drag fill as the G1 stays G1 when I drag to fill. Any help is greatly appreciated.
Maury
You could use a 3D reference with VSTACK.
=VSTACK('G1:G5'!K24)Notice the arrangement of the sheets:
Patrick2788 Hi Patrick, The VSTACK option did not seem to work but the indirect address formula did. The VStack would be much easier but I cannot get that one to fill down
Thank you so much for the help!
- It sounds like you're not using Excel 365 so you're getting a #NAME? error possibly.
