Thread: linking the data between 2 cells

Hello forum i am looking for some assistance.

i have a sheet with basically:
column 1 are names : A1:A200 are a list of names(driver)
column 2 are #'s: B1:B200 are a list of numbers (place on seniorty list)
column 3 are #'s: C1:C100 are a list of numbers (daily rotutes)
this is basicallly a seniority list that i have of drivers and there place on list.


here's the problem.

I need to move the names around as i assign different routes to each driver daily.
what i need is for the # on the senority list to move with the drivers name.
if i palce a driver on a diiferent route is senority number will move with the name and appear on the same row.

thanking you in advance
-cheda
Go Giants!!!

Cheda, it seems to be a very simple list but I don't understand the concept... Anyway, let me see if I can help you.

You have two columns A and B with Number and Names. What you can do is add (insert) a 3rd column that concatenate columns A and B and you can move the data in this column.
To concatenate data from A&B on c you select cell C1 and enter this formula: =A1&B1
If you want to keep a space or a line betweeen the number and the name you can use =A1&" - " &B1

Hope it helps