master sheet

Did I ask a stupid question or not in the correct format? if so let me know i will change it im new to all of this i have never used a forum

Do you have a screenshot of the sheets containing the information?

the screen shots are attached to my post

You want the currently blank sheet to be a summary of the unit so that sheet one unit 101 would be a total of all the AM Mileage etc? Just want to make sure that I am understanding

i want the master sheet to do what each separte sheet does so i can print only one sheet to see my whole fleet for my boss to review

this is how it works the am mile are the pm mile from the day before i just put in the pm miles at the end of each day everything else fill in own its own i want sheet 44 which is my master sheet to reflect all sheets on 1 sheet so when asked for totals i can print only 1 sheet for the entire fleet sheet 1 is 101 sheet 2 is 102 so on and so forth

i may not have my master sheet set correct if you have a ideas im open i just need to know mileage by day /week/month/year on the master sheet

the reason i did am and pm on my master is cause i will save each sheet daily by date so i can submit to my boss and i though it would help populate daily ,weekly,monthly,yearly on my master

did i loose you?

Diablito,

all membres here are volunteers working on their spare time you cannot expect them to be at your disposal 24 hrs a day.
Our forum rules ask that you wait 24 hrs before bumping one way or another.
What's more, it is useless to create a new post every ten minutes adding some new info.
If noone answered your last post, you can edit it an add the new info ( eventually preceded with the wordt EDIT)

wow i didnt intend to make you mad i think if you read close you can see im new to this sorry if i did something wrong point me to where i can delete my account and you wont be bothered by me any more

If I was doing it the way I would want to would be to have a total each day being created because if you SUM everything and do those totals then your mileage will be HUGE.
As such you need to have a program not a formula that will look for each day and update it daily. Unfortunately I believe that is beyond my abilities as I am much better with formula and linking etc that with programming.
However what if you did the reverse entered the information on the master sheet and then it filled in the rest? Still a little time consuming but off the top of my head probably easier.

Would you be able to post the a copy of the documents themselves, not just screen shots, with all the secure / private information removed?

check your PM