Hey all,
I have a main sheet with personnel and some data. Each person should get a separate sheet name ex: "Kent, Clark" on main sheet should have a sheet named "Kent-Log" in the same workbook.
I have a template setup already for Kent. What I am looking to do is when I enter a new persons name(Last, First) on the main sheet, i want VBA to copy "Kent-Log" and rename to "Last-Log". I have several people to add and am trying to avoid -copy ->move to end--> rename
Any help is greatly appreciated.
Bookmarks