I have a sheet in a workbook "Sheet Names List". Colum A has numbers 1 - 42 in rows 1 - 42. Column B has the following formula =IFERROR(INDEX(ListSheets,A1),""). I just need a macro that will "Refresh" this index list.
the reason for the need is because whenever I copy an exiting worksheet (as a template) and rename it, the "Sheet Names List" does not update with the new sheet name and continues to reference the old sheet name unless I manually refresh the formula. I want this to be automated.
Please can you assist
the reason for the need is because whenever I copy an exiting worksheet (as a template) and rename it, the "Sheet Names List" does not update with the new sheet name and continues to reference the old sheet name unless I manually refresh the formula. I want this to be automated.
Please can you assist