ExcelBanter - How can we automatically update page numbers for inserted tab?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can we automatically update page numbers for inserted tab? (https://www.excelbanter.com/excel-discussion-misc-queries/175063-how-can-we-automatically-update-page-numbers-inserted-tab.html)

Vivek Mittal

How can we automatically update page numbers for inserted tab?

Please have a look onto this scenario.

I have an excel sheet with multiple tabs. They all have page numbers in
sequence. Now I insert a new tab between two tabs. I want page numbers to be
automatically updated for all tabs.

How is it possible?

All times are GMT +1. The time now is 07:14 PM.