Hi,
I wonder if someone could guide me please with VBA code :
I have list of of names in Column A1 to A100 - I would like to VBA to do the following when pressing Macro button :
- Create a new sheet
- Paste Name from Column A1 to new sheet in Column B3 (so on for every name with new sheet and paste name)
- Change the sheet name to the same name as in Column B3
- If sheet already exist with the same name than ignore it and move to the next one
- If the sheet exist but that name isn't in the list in Column A1 to A100 than delete that particular sheet.
I'd really appreciate you guidance.
Many thanks,
I wonder if someone could guide me please with VBA code :
I have list of of names in Column A1 to A100 - I would like to VBA to do the following when pressing Macro button :
- Create a new sheet
- Paste Name from Column A1 to new sheet in Column B3 (so on for every name with new sheet and paste name)
- Change the sheet name to the same name as in Column B3
- If sheet already exist with the same name than ignore it and move to the next one
- If the sheet exist but that name isn't in the list in Column A1 to A100 than delete that particular sheet.
I'd really appreciate you guidance.
Many thanks,