Excel 2011 for Mac - command to create new form and name sheet according to date entered

scheermadness

New Member
Joined
Feb 24, 2016
Messages
2
I'm trying to create a very user friendly form for a team of mental health workers, who are not tech savvy.
Essentially, it's a progress note that is filled out after each session. I'd like for the template to carry over to the next sheet and be named the date of session that the therapist enters in a particular cell.
Rather than copying and pasting the form on multiple sheets, I'd like the user to be able to hit a button that brings up a new sheet, which will be automatically named "mm-dd-yy" as soon as she enters that information (which will hopefully be via a date picker.)

As each session gets its own note (and sheet), I'd also like to have the "Session #" cell be automatically populated - sequentially.

I mentioned that the therapists are not tech savvy, but I am not an expert by any means, so I struggle with understanding code writing.

I'm using Excel 2011 for Mac.

Please help. You're my only hope, Obi Wan.
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Watch MrExcel Video

Forum statistics

Threads
1,118,049
Messages
5,569,884
Members
412,298
Latest member
dietitiann
Top