Hi folks!

Looking for the best way to perform a painfully repetitive task!

I have 2 sheets of data.

- A master sheet with all records (customer data - about 65,000
records/row)
- A completion sheet with partial data (customer data - about 50
records/rows)


The master sheet looks like this:

Job Num Job Type Tech Name City
State
1069478 Commercial CH25 Joe Smith Ashlan KY
1068202 Commercial CH25 Steve Jones Portsmouth OH
1061548 Commercial CH25 Kevin Phinney Portsmouth OH
1014500 Residential CH25 Arnold Wright Argillite KY
1071035 Residential CH25 Tim Blue huntington WV

The completion sheet looks like this:

Job Num Status
1068202 Completed
1061548 Completed
1071035 Completed


I need to use the "Job Number" range from the completion sheet to pull
the entire matching record/row from the master sheet and paste or
display it in a new sheet or the current sheet or .... heck I will take
it anywhere! As long as I can search for all completed jobs from the
completion sheet in the master sheet all at once!

Any help on this is much appreciated! We have been trying to figure
this one out for a long time!


--
egeorge4
------------------------------------------------------------------------
egeorge4's Profile: http://www.excelforum.com/member.php...o&userid=30259
View this thread: http://www.excelforum.com/showthread...hreadid=552996