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.

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.

[110mama]

I think you and I are trying to accomplish a similar task. Your terms actually helped me to find what I was looking for on another sight.

I'm a mystery shopper and I "shop" for different companies. For each company I made an individual sheet. I then listed the individual jobs with their date and fee, and added up the totals. I wanted to link the total income earned from each company to a final sheet, so that I could add each amount together for a final sum of what I earned in 2012.

I found the following reference, which is exactly what I was looking for. Not sure if this is fully what you are looking for, but it's a start at the very least.

"When linking cells in worksheets that are in the same workbook, you can enter the formula manually. Type =SheetName!CellReference. The formula in our example would be =Atlanta!B6."