I would like to rename the tabs (sheets) at the bottom based on what is entered in cells P2 and W2. Each sheet will be for an employee, cell P2 has a drop down list for the site they work at and W2 is where I enter their name. So I would like it to read SAT John Doe. This should work only on the sheets that are not hidden.
I have seen examples of doing it from one cell but not two
Thanks
edit...Also crossposted here, sorry didn't know that rule. I will post a link from the other site to here when I respond back to my question. Again sorry about that
http://www.mrexcel.com/forum/excel-q...two-cells.html
Bookmarks