Hi All,
See the attached spreadsheet for exact details, but basically what I want is:
The employee will fill out their workload for each day on the "MAIN INPUT" sheet, then, based on what the cell says in COLUMN E, I want a macro linked to a button that will copy the different outcomes, to the sheet with the matching name which I have already created.
I also need them to appear on their sheets with no rows blank inbetween, with no duplicates, and in the same order as they appear on the "MAIN INPUT" Sheet.
I want the macro linked to a button that the employee can press to update the workbook.
I also want the employee to only be able to scroll from: Columns A - K, and rows 1-2000.
Can this be done? I hope so!
Any questions or if i'm not being clear, do let me know!
Thanks so much!
Chris
P.S. I have had a go at writing some code for the scrolling thing which I don't think works, may be best to just delete that and start over! Thanks!
Bookmarks