So yeah, I'm pretty sure this is a simple issue but it's one that I am not able to get my head around, at least at the moment. Currently I have two sheets; a Data sheet (Sheet1) and Sheet2. I would like to be able to enter a program name in cell A2 of the Data sheet (Sheet1) and once I execute the macro, Sheet2 is automatically renamed according to the data entered.
Bookmarks