I have an Excel worksheet (attached) that I would like cell A30 to contain part of the filename and the entire tabname.
For example, the attached filename is DTL-EE-1711-Rev3.
I have successfully gotten EE-1711- to print in A30. Now I would like to add the Tabname to the cell so that the cell prints
EE-1711-02 in A30
For internal security reasons, I would prefer this is done with VBA instead of an Excel formula.
Obviously, by the end of the month, there will be Tabs 01, 02, 03, 04 ... through 30 or 31 skipping Saturday and Sunday.