Afternoon all,

I am trying to create a VBA macro that creates a new worksheet in a workbook at the click of a button. The problem I have is that I would like this worksheet to be named after the value (a date) in a certain sell (say A1). Also, I would like the macro to NOT allow two worksheets of the same name (with (1) etc.) to be created, but for the macro simply to take the user to the sheet already created, should they select a date for which a sheet already exists. Finally, once a new sheet has been created, I would like the user to be taken to this sheet.

While I have figured out the macro to make a new sheet, the naming and the rest of it is proving challenging. Does anyone have any good ideas?

Thanks in advance!