I am looking to create a workbook in which on one sheet, lets call it the MAIN SHEET, i would type in the information that I am wanting to track. Things that I would like to track would be Job #, Month Name, Date, Loads, Product, Gross Weight, Tare Weight, Deduct Weight, Net Weight, Tons, Landfill, Driver, Truck #, Driver Ticket #, Dump Fee, Dump Fee/Ton, Ticket $/Load, Total $, Total $/Ton, and Landfill Ticket #.

The way that we have been doing this is to type in the information into each single cell. We have not found an efficient way to look at this data without having to type it out a couple times or copy and paste it to a lot of other sheets.

Ideally, we would like it to type the information on the MAIN SHEET, have it transferred to the correct workbook based on the job # (maybe an IF statement would know which sheet to put it in?) and have the rest of the information fall into line accordingly. We type in new information daily and don't want to have to "reinvent the wheel" each day. (I don't know if this part is possible. If we have to type in the information on the seperate job sheets, I suppose that would still work)

After the information has been entered into the correct job worksheet we would like it to go to the summary sheets based on the product, i think that this can be linked from the main sheet automatically (or the job sheets somehow, my brain is frying from thinking about this). It would be nice to see it all in a pivot table which also updates with the information automatically. The fewer steps for us, the better.

Attachment 207152

^^^^^ATTACHMENT ^^^^^


Unfortunately, I don't have the expertise to write these formula's or figure it out. I have been trying different things for the past 2.5 days!! I have included an example of what I would like to have it laid out as, I just can't figure it out!! Any Help would be appreciated.