Forum Discussion
Solved
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 n...
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.
- That's strange, I just purchased office 365 Professional for my office, and have been using it in previous years from my old job.
IMHO, there is no such product as "Office 365 Pro". Perhaps you purchased Office 2021 Pro.
