Cell Crit Memory?

[HoundofCullin]

Once again I ask for your help,

I have a sheet that contains various fields for entering information
about trucks running through (Gross wt. Tare wt. Material hauled etc.)
that changes on a daily basis.
I want to know if I can get something set up so that after the first
entry of a truck (say truck #45) is entered, along with the appropriate
tare and materials, Excel remembers the Tare and Material for future
entries of the same truck.

I.e.
I enter the trucks number (45) in cell G5, and the tare in F15 and
the Materials in G11. The truck's Materials and Tare are the same all
day.
I need Excel to automatically "memorize" those bits of information so
when next I enter "45" in the truck number cell it automatically enters
the Material AND Tare in the appropriate cells.


If you need me to clarify my crit a bit more, please ask.

Thanks for any help in Advance,

Josh

 

[Squid]

Sounds like a job for a VLookup function. Create a
database for the trucks. For example in a worksheet
called trucks have the following columns: Truck#, Gross
wt. Tare wt. Material hauled, etc. Then in another
worksheet (or the same one), create the vlookup function.
Your truck# would be your lookup value. Insert the
vlookup functions where needed. Refernce Vlookup in Help
for more details.