*** See additional remarks under original post ***
Morning all
I have a spreadsheet that tracks the activity of staff based on 8 different options. This main sheet then feeds further sheets that then provide the various stats we need for each staff member.
What I'm after if someone can help is that when the workbook is opened, a window pops up asking if we want to add new data. If the answer is no, them it closes and we can work on the workbook as required.
If the answer is yes, a further window would open with an option to insert a date, and 2 columns. One would list the staff initials as per row 2 - SB LW MV etc and the second column would then have an input option to insert one of the 8 options (FL OD OF AD etc). Once the boxes are populated, it would then add a 1 into the relevent column against the relevent date in column B and as long as my conditional formatting works, the rest of the cells would be populated with zero's. The conditional formatting hasn't copied over onto this attachment, but at the moment I scroll along each row each day and insert the 1's and the zero's do appear.
I realise it's a big ask, but if anyone can help, it would be greatly appreciated.
regards
*** I have managed to create the user forms, I just do not know how to get the forms to pop up initially and also then to relate which text box provides which bit of info ***
Bookmarks