Hi
I need some help trying to figure out how to do the following:
I have about 10 workbooks in a week. They represent company deliveries. Each workbook has 6 worksheets with a calculated total of the number of delivery stops in each worksheet. The Worksheets are saved in AM & PM, but with specific dates.
Example: DLog 17 OCTOBER AM / DLog 17 OCTOBER PM.
What I need to do is consolidate each worksheet for AM & PM count, then that info needs to automatically be put into a specific date row in a consolidated workbook. This info is required weekly, but gives a monthly total.
I don't know if I am explaining correctly.
if anyone can point me in the right direction, I would appreciate it very much.
Thanks
I need some help trying to figure out how to do the following:
I have about 10 workbooks in a week. They represent company deliveries. Each workbook has 6 worksheets with a calculated total of the number of delivery stops in each worksheet. The Worksheets are saved in AM & PM, but with specific dates.
Example: DLog 17 OCTOBER AM / DLog 17 OCTOBER PM.
What I need to do is consolidate each worksheet for AM & PM count, then that info needs to automatically be put into a specific date row in a consolidated workbook. This info is required weekly, but gives a monthly total.
I don't know if I am explaining correctly.
if anyone can point me in the right direction, I would appreciate it very much.
Thanks
