I've got a question about VBA, I am very new to this and I have been asked to create a sheet to record time for certain tasks.
This is what I have made so far so you can get a better idea of what I have constructed:
Essentially, user clicks on one of the 4 client buttons, start time is recorded and the name of client. They then click the subtask to record what they are doing for the client, and then end button to record the final time. The difference in the times is recorded.
I now want, on the same sheet to be an Export button, and every Friday, the data is exported to the next sheet. The information I want on the next sheet is a table in the format shown on the figure.
So essentially, the macro will read the date, work out the day and total the time spent working on the entire day (productive time), then by clients, then by subtasks, and then the weekly totals. I know it is probably a pain to explain but any help would be thoroughly appreciated.
Imgur: The most awesome images on the Internet
I look forward to hearing from you all!
