Forum Discussion
Spilling a Worksheet Name
Hello, I am currently using data from many different worksheets in one workbook. I would like to be able to use the same exact formula on a "Master" data sheet that compiles data from all of the work...
=INDIRECT(ADDRESS(1,1,,,A1))You can try this formula. You can enter "sheet1" in cell A1 and spill down. Column C shows the result of the ADDRESS formula.