Linking Data --- NEED HELP!!

[jaarthur]

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.

Example.xlsx

^^^^^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.

[swhitesell]

Are you trying to solve this problem in Excel or do you want an Access database that produces reports? If you want to stay with Excel you may want to delete this post, and repost your question in the General Excel forum.

[jaarthur]

I didn't realize that I had posted it in this section. Would access be a better program for what I am trying to get accomplished? Or would excel do the job?

[vlady]

Since you've created another thread in the Excel section i will be closing this thread, you may continue in the other thread located at
http://www.excelforum.com/excel-gene...need-help.html

thank you.

Thread Closed.