Using existing spreadsheet (provided)
Create button that will save workbook, and use a cell reference as the file name & Save PDF at same time
Create button that will clear specified cells , and advance "current schedule date" based on cell reference
Create Email button, save PDF as [masthead] E19, in same directory as schedule (can change based on store/year). Email staff the PDF file, with a body of text stored in a cell.
Create one worksheet [PRINTABLE] that displays all stores on one page, that will
dynamically inserts staff names if scheduled, and scheduled hours for that day. Maximum 4 staff, otherwise display "-", displayed in standard calendar format, includes sales goal., includes day & date.
Décerné à :
That sounds relatively straightforward and only a small amount of data so I have estimated a day's work and so a bid of 100USD. I have been building Excel VBA applications for over 10 years, for your reference.