I have a workbook that will contain a different number of sheets and in different order depending on the scenario that is auto populated using VBA.
The format the company uses for numbering the sheets is "Page 1 Of 10" (for example) with "page 1 of" in one cell and "10" in the cell next to it. I need code to auto populate "page 1 of", "page 2 of", page 3 of", etc. in each visible sheet. The cell range is the same of every sheet (A9 & A10). I was thinking I can use a list and write code to copy each line in the list to each subsequent sheet. Does anyone know how I could write this, or even have a better way of doing so? The issue I am having is having consolidated information in cell A9. Thanks in advance!
The format the company uses for numbering the sheets is "Page 1 Of 10" (for example) with "page 1 of" in one cell and "10" in the cell next to it. I need code to auto populate "page 1 of", "page 2 of", page 3 of", etc. in each visible sheet. The cell range is the same of every sheet (A9 & A10). I was thinking I can use a list and write code to copy each line in the list to each subsequent sheet. Does anyone know how I could write this, or even have a better way of doing so? The issue I am having is having consolidated information in cell A9. Thanks in advance!