Got any Excel Questions?Quickly insert all sheet names in cells with VBA If you want to inset all sheet names in cells, VBA macro is a good choice Step 1 Hold down the Alt F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window Step 2 Click Insert > Module, and paste the following macro in the Module Window Your example says you want to lookup from a sheet named a number that is 3 less than the row that the cell is on in the Summary page and you are always referring to cell in that referenced sheet (B4 of my summary page to reference to a sheet titled "1" and have cell , cell B5 to display Sheet 2 cell ) This is an unstable configuration
1
