Baby steps.....

[cpegram]

I have had no training whatsoever in Excel. What very little I know I have picked up by using existing worksheets. Unfortunatly I don't have a lot of time to spend learning the system right now.
To put it short....I'm inexperienced and inept.

I have several sheets I have created to manage a vehicle inventory. Currently, they are not tied together in any way. So, if I have to make a change to one, I have to change them all.

I think what I need probably has a simple solution, but I haven't been able to figure out what I even need to ask or look for to find the solution.

In short, I need to link a truck number to a route number on a master sheet.
I then need to be able to type the route number on another sheet and have the truck number appear in the adjoining box. Sounds simple...I'm sure it probably is.

Thought one of the experts here could throw an old dog a bone...

[keithl816]

Hi cpegram,

try this in new excel spreasheets 1 & 2 (As a test)

Spreadsheet 1

A1 truck Numbers

A2 to A7 Enter random truck numbers

B1 Route Numbers

B2 to B7 Enter random route numbers

Sreadsheet 2

A1 Truck Numbers

A2 to A7 Enter Your list of random truck numbers

B1 Route Numbers

B2 Enter this and drag down to B7

Please Login or Register  to view this content.

Will this help?

[cpegram]

B2 Enter this and drag down to B7

After I enter the formula how do I drag it down to B7....when I type it in B3 I get the value for B2

Like I said...I don't know much

[keithl816]

In sheet 2 single click cell B2 You will see a little black box in the lower right corner of that cell left click holding the mouse and drag down to B7

[cpegram]

Wow.

The internet is a wonderful thing.
Thanks for the help.

[keithl816]

Glad to help.