chocolatedogs
New Member
In the sample file: the yellow shaded areas are user input, but in stages. I want to put in start date and auto populate the workdays (workdays are M-F, excluding Sat and Sun) for the month - this should (could?) happen for the whole month when the start date is entered.
The project name is added by user starting in cell C2, and the hours worked are added by user in Column E. The data for each day will be input row by row as the month progresses, not all at once. Each week also needs to be automatically subtotaled along the way too, as given in Row 4, etc.
I want the next day's row to automatically put in the project name from the previous row, so they don't have to be re-entered. I know the autofill sort of does this, but the different project names are really lengthy and there is a lot of duplication in their names until the last few characters, so typing in/autofilling is not a good option. I don't want to just put C3 = C2 for project name, since that would fill in the whole column at once using formulas once the first entry goes into cell C2. I just need row by row, one at a time (it would be great to fill in all the dates in column B at the start of the month, but figure it all goes row by row together, and doing one whole column then some columns one row at a time is way too complicated and is really not necessary). Ideally each month would be on its own tab, but that adds another huge wrinkle code wise.
I will admit I have spent a lot of time trying to use cleverdate/time formulas and not making it so complicated, but that effort failed miserably, hence I arrived at a macro/VBA. I must admit I don't know where to begin - I have confused myself terribly and thought I should ask the experts for their help/perspective.
The project name is added by user starting in cell C2, and the hours worked are added by user in Column E. The data for each day will be input row by row as the month progresses, not all at once. Each week also needs to be automatically subtotaled along the way too, as given in Row 4, etc.
I want the next day's row to automatically put in the project name from the previous row, so they don't have to be re-entered. I know the autofill sort of does this, but the different project names are really lengthy and there is a lot of duplication in their names until the last few characters, so typing in/autofilling is not a good option. I don't want to just put C3 = C2 for project name, since that would fill in the whole column at once using formulas once the first entry goes into cell C2. I just need row by row, one at a time (it would be great to fill in all the dates in column B at the start of the month, but figure it all goes row by row together, and doing one whole column then some columns one row at a time is way too complicated and is really not necessary). Ideally each month would be on its own tab, but that adds another huge wrinkle code wise.
I will admit I have spent a lot of time trying to use cleverdate/time formulas and not making it so complicated, but that effort failed miserably, hence I arrived at a macro/VBA. I must admit I don't know where to begin - I have confused myself terribly and thought I should ask the experts for their help/perspective.