Copy paste Rename based on cell value

Josephnb Posts 2 Registration date Tuesday November 15, 2016 Status Member Last seen November 16, 2016 - Nov 15, 2016 at 03:40 PM
 Josephnb - Nov 21, 2016 at 08:28 AM

I have a worksheet named template. I need a VBA code which would copy "template" automatically into a new worksheet and rename the new worksheet based on the value from two cells in "template".


2 responses

yg_be Posts 22496 Registration date Sunday June 8, 2008 Status Contributor Last seen February 27, 2024 5
Nov 15, 2016 at 04:19 PM
The easiest way to achieve that is to start recording a new macro, then manually do the operations (creating a new worksheet, copying template to the new worksheed, renaming the new worksheet.
Once you have that macro, you will easily (perhaps with some assisitance from this forum) adapt it according to your needs.