Hello everyone
Please see attached.
There are a number of sheets that start with P**, where ** is a number that changes. For example, today it is 01, tomorrow it will be 02, then 03, all the way to 12
I would like a macro that finds the sheets whose name starts with P** and changes the ** to a value in cell A1 of Sheet5.
Would appreciate any assistance on this.
Bookmarks