I have a series of columns in a Summary worksheet that reference data in a series of worksheets. I am comparing the data in each worksheet.
Each column is headed by a header cell that contains the name of the worksheet.
e.g. DR00 DR01, DR01, DR02, etc..
Several rows down I have a cell that contains a worksheet reference that pulls the data from a cell in that specified worksheet.
I want to create a Cell Formula that uses the INDIRECT function to pull the worksheet reference from the header cell.
I don't know what syntax is correct here. Excel keeps telling me my formula is incorrect.
Can someone look at my text workbook and give me the correct formula. I'd also appreciate a little explanation as to why my syntax is not working. Thanks.