E
excelhurtsme
I have created a daily report for manhours on a specific job. The worksheets
are to be created as needed in the report for the number of days on the job.
The field I am having trouble with is titled total hours from start of job. I
know that a dummy worksheet can be put in front and back and referenced in a
sum, but it changes all of the days to the total of the last day entered. I
need a formula that updates itself everytime a sheet is created and sums all
hours from start of job to it. I have come up with a formula generator that
updates beautifully, however I cannot get the results of this formula to
enter into the target cell and update itself as worksheets are created. The
formula generetor updates nicely as sheets are created, and I have tried to
copy and paste special "value" and it works on that particular page but when
another worksheet is created the cell returns a #ref error.
are to be created as needed in the report for the number of days on the job.
The field I am having trouble with is titled total hours from start of job. I
know that a dummy worksheet can be put in front and back and referenced in a
sum, but it changes all of the days to the total of the last day entered. I
need a formula that updates itself everytime a sheet is created and sums all
hours from start of job to it. I have come up with a formula generator that
updates beautifully, however I cannot get the results of this formula to
enter into the target cell and update itself as worksheets are created. The
formula generetor updates nicely as sheets are created, and I have tried to
copy and paste special "value" and it works on that particular page but when
another worksheet is created the cell returns a #ref error.