I am trying to make it easier to enter expenses into worksheet by running a private macro upon opening of the worksheet. The first inputbox will ask the user for the date of the transaction. I want the macro to be able to recognize the date and enter the information into the correct cell in the corresponding worksheet (January, February, March...). From there, once the information is being entered in the correct sheet, I want to ask for other information that should be entered next to the date cell.
I can figure out the inputboxes but I don't know how, or if I can, have the macro recognize the date and automatically link to a specific worksheet.