I have what seems to be an unsolvable problem. A challenge for you Guru's.
I fill out a new timesheet (see timesheet tab) each day. That information from the timesheet is copied to the appropriate row on the WorkCompCore sheet.
I start out with a blank timesheet each day.
I need all of the information that is added on the WorkCompCore sheet saved and compiled it each day from the timesheet.. As I add new data onto each new timesheet, I need that data added to the WorkCompCore sheet and saved each day also. Remember, each day starts a new timesheet with new data to be added. I can do all of that just fine.
Heres the problem. Lets say I enter info for the road Label 1 on a certain day. If I enter data say 5 days later on the same road, I will need to add a new row under road Label 1 on the WorkCompCore sheet, for the new data and so on. I need Excel to look for the road label number when it is entered on the timesheet and if data has already been entered for it on a previous day on the WorkCompCore sheet, then make a new row under it for the new data on the WorkCompCore sheet.
I need all of the formulas from the cells above the new row to be usable in the new row also.
This should be quite a test.I'm all ears.![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Roll eyes :rolleyes: :rolleyes:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I fill out a new timesheet (see timesheet tab) each day. That information from the timesheet is copied to the appropriate row on the WorkCompCore sheet.
I start out with a blank timesheet each day.
I need all of the information that is added on the WorkCompCore sheet saved and compiled it each day from the timesheet.. As I add new data onto each new timesheet, I need that data added to the WorkCompCore sheet and saved each day also. Remember, each day starts a new timesheet with new data to be added. I can do all of that just fine.
Heres the problem. Lets say I enter info for the road Label 1 on a certain day. If I enter data say 5 days later on the same road, I will need to add a new row under road Label 1 on the WorkCompCore sheet, for the new data and so on. I need Excel to look for the road label number when it is entered on the timesheet and if data has already been entered for it on a previous day on the WorkCompCore sheet, then make a new row under it for the new data on the WorkCompCore sheet.
I need all of the formulas from the cells above the new row to be usable in the new row also.
This should be quite a test.I'm all ears.
Last edited: