Column Compare

[rabalam]

So I will try and explain to my best ability as to what I am trying to acomplish.

U have two sepreate spreadsheet for name sake we'll call them SheetA and SheetB.

I have information in Column a, b, C, and D in sheetA
I have information in Column a, B, c in sheetB

The format of information on sheetA column A 1901234 unsorted

The format of the information on sheet be column A abcdefg1901234 unsorted

I am tryin to compare the two documents and the columns and actully try and match them up so that they can appear in one document side by side.

I am curently going line by line from sheet A doing a search and find and the equivalent last 7 digits and adding the information maually. Well I have over 500 devices I have to this for. I knwo there got to be a short cut. Any help would be greatly appreciated.

Thanks,

 

[rabalam]

Thank you soooo much, I'm doing the happy dance about right now wooo hoooo you saved me so much work..

As I stated before I owe you..

~g

 

[mgirvin]

You don't owe me, you owe you!

What you owe yourself is to teach yourself Excel so you have the POWER!

Here are some video playlists that teach the foundations of Excel:

Excel Basics Series
http://www.youtube.com/view_play_lis...BEE51974F03CCF

then

Highline Excel Class Beg - Adv (Complete Class - 59 videos)
http://www.youtube.com/view_play_lis...EEA7196D943ED5

Workbooks that you can use to follow along and learn Excel:

http://flightline.highline.edu/mgirvin/ExcelIsFun.htm