Hi, I'm trying to convert a time sheet report in excel to individual reports per user and project. I've attached the base report below. Basically, I want to create a worksheet per new value in the "Project" column (A) and also add worksheets for each change in the "Created by" column (E).
The resulting sheets would each contain all time transactions for that specific value.
Another option might be to create separate files for each variation with the column value + the current date being the file name.
I tried the following which I copied form another post and does most of the job, but it fails when the data isn't sorted correctly (only includes first values found and tries to create a duplicate sheet):
As a last resort, I can add a sort statement and repeat the subroutine for the "created by" column, but I'm hoping for a cleaner solution.
Bookmarks