Hey guys I have two questions about "tab" or "sheet" referencing.
1.) Is there any formula that will extract the first Sheet name in the workbook and if I drag this formula down it will extract the next sheets name in the workbook.
2.) If in cell I11 I have the name "adherence" Is there anyway in cell J11 will reference cell G19 in the sheet titled "adherence" which is the input in cell I11. So essentially if I change the name in cell I11 it will reference another sheet.
Thank yall so much!
Bookmarks