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.
 

Forum statistics

Threads
1,082,478
Messages
5,365,789
Members
400,851
Latest member
FrankNStein

Some videos you may like

This Week's Hot Topics

Top