Baby steps.....

C

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... ;)
 
K

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


Code:
 
C

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 :)
 
K

keithl816

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