I need help with simple excel formulas, I have 5 fields for data that need to be filled into 2 sheets in the same workbook.
It would take me months to figure out the formulas, I need help with 3 formulas.
Here is a description of what I am having trouble with creating.
DashBoard to Chart
(Formula #1) Name entered in dashboard
When name is entered into script it should FIND name (not ref to cell #) in list on Chart and put the data into that row for that person
(Formula #2) Vacation Month and Day entered in dashboard
In name row in (Chart) Month column, number of hours should go there (we should be able to add additional hours to this cell which would add to existing value) ( we should also be able to change month and day, incase employee changes the date for booked vacation)
DashBoard to (Calendar Month)
(formula #3) Type of Time off (code) BOT or VAC or SAF (example…. Chris P – BOT)
Vacation Code next to name in Calendar in sheet 3 (example…. Chris P – BOT)
The only thing in the calendar will be the employee name in the first open cell in the calendar box for the date requested with the three digit (Code) after.
On calendar, there are 6 cells for each day, if first cell is occupied then put next name entered into next available cell under it.
I hope that kind of makes sense.
I have the Workbook designed with all the sheets ready to go, I just need help with the formulas.
Thanks so much.