Niranjanrajrishi
Member
Hi,
Would like to seek help to create workbooks based on the sheets available. For each worksheets we need to consider the first 4 letters and create one workbook with 2 different sheets.
For example: we have 2 sheets "5A00" and 5A00 - Parked". These 2 sheets should be created as one workbook with the name 5A00 - Blocked and Parked with the current date.
Another example: We have 2 sheets "5N00" and 5N00 - Parked and these sheets should be considered to create new workbook and name it as 5N00 - Blocked and Parked.
For each time the no of of sheets in each workbook (new work book to be created) will be two but there might be more workbooks to be created based on the worksheet we get for each cases.
I tried to get code but could not get it.
Can you pelase help me?
Would like to seek help to create workbooks based on the sheets available. For each worksheets we need to consider the first 4 letters and create one workbook with 2 different sheets.
For example: we have 2 sheets "5A00" and 5A00 - Parked". These 2 sheets should be created as one workbook with the name 5A00 - Blocked and Parked with the current date.
Another example: We have 2 sheets "5N00" and 5N00 - Parked and these sheets should be considered to create new workbook and name it as 5N00 - Blocked and Parked.
For each time the no of of sheets in each workbook (new work book to be created) will be two but there might be more workbooks to be created based on the worksheet we get for each cases.
I tried to get code but could not get it.
Can you pelase help me?
Last edited: