Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare and extract using a program. i really need help.
I have a task at my work whereby it requires me to extract the Staff ID from one spread sheet to another by comparing the User ID. It is very time comsuming since there are more than 6000 numbers to copy. Now, what I want to do is simple, all I want is to extract the Staff ID from one spread sheet to another in the correct cells. Thats easy but here is when it gets complex. Spreadsheet 1 Staff ID .... .... .... .... User ID sgfd soip stya swjk Spreadsheet 2 Staff ID 123 456 789 159 User ID sgfd soip stya swjk I just need to know how to start. Thanks for anyone's help. ayunik -- ayunik ------------------------------------------------------------------------ ayunik's Profile: http://www.excelforum.com/member.php...o&userid=24317 View this thread: http://www.excelforum.com/showthread...hreadid=379224 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare and extract using a program. i really need help.
Need to explain in detail -- anilsolipura ----------------------------------------------------------------------- anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627 View this thread: http://www.excelforum.com/showthread.php?threadid=37922 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare and extract using a program. i really need help.
pedestrian method is
in sheet 2 the col A is userid and col B is staff id -both with heading rows in sheet 1 col A is user id with the heading. in B2 type =VLOOKUP(A2,Sheet2!A1:B5,2,FALSE) copy B2 down. is this clear. change A!:B5 to suit you. there are other sophisticated methods. ayunik wrote in message ... I have a task at my work whereby it requires me to extract the Staff ID from one spread sheet to another by comparing the User ID. It is very time comsuming since there are more than 6000 numbers to copy. Now, what I want to do is simple, all I want is to extract the Staff ID from one spread sheet to another in the correct cells. Thats easy but here is when it gets complex. Spreadsheet 1 Staff ID ... ... ... ... User ID sgfd soip stya swjk Spreadsheet 2 Staff ID 123 456 789 159 User ID sgfd soip stya swjk I just need to know how to start. Thanks for anyone's help. ayunik -- ayunik ------------------------------------------------------------------------ ayunik's Profile: http://www.excelforum.com/member.php...o&userid=24317 View this thread: http://www.excelforum.com/showthread...hreadid=379224 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare spreadsheets & then extract data | Excel Discussion (Misc queries) | |||
Compare and Extract | Excel Worksheet Functions | |||
Program error when using Compare and Merge Workbooks | Excel Worksheet Functions | |||
compare lists, extract new values | Excel Discussion (Misc queries) | |||
Is there a way to create a program in excel to compare files? | Excel Programming |