Hi,

I have a budget workbook for logging staff expenses that uses a macro to create either a travel, conference, or consulting fee worksheet when the associated button is clicked. The new worksheet has the name of the staff member and type of expense in abbreviated form.

If the staff member has already created their specific worksheet, then they would click on a button from the main worksheet that would take them to directly to that worksheet to amend.

I'd like to consolidate this so that one button for each type will either create the worksheet if it doesn't exist or just go directly to that sheet. Can anyone recommend what would be the best way to check on the existence of a worksheet and, if not found, then to create it?

Thanks,
Reinaldo