kingcashandcarry
Member
i have a workbook (wb1)with several sheets. copy the active sheet to another workbook that is stored in folder z:\catalogue in xlsm forms but the filename will be the same as a cell value (ah33) in active sheet after the copied sheet will be renamed as sheet +1. if there is a sheet name sheet1 so the copied sheet will be renamed as sheet2