Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Firevic
 
Posts: n/a
Default Database comparison challenge!


Hello everyone:

I need to compare tow data sheets. The first one is aprox 300 cells
long
and have this format:

001254 Driver Side Rear Discharge
204451 AirInlet Lower Step of Cab

and go on.

The second one have numbers, aprox 5000 like this


023540
045789
020144.

I need a macro that compare the first sheet to the second one, and when
the same number is found from the first one on the second one
create a third sheet with the common number on the first one plus the
description. Thanks for helping me with this challenge.


--
Firevic
------------------------------------------------------------------------
Firevic's Profile: http://www.excelforum.com/member.php...o&userid=23955
View this thread: http://www.excelforum.com/showthread...hreadid=375803

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import from Database using field from excel. BD Excel Discussion (Misc queries) 1 May 10th 05 10:31 PM
The Template Wizard retains the original location for my database Packwood Excel Discussion (Misc queries) 0 April 15th 05 05:25 PM
Graphing Database Growth Rate DavidM Charts and Charting in Excel 1 February 2nd 05 12:01 AM
Query a Access database that has a module from Excel Oggie Excel Discussion (Misc queries) 1 January 4th 05 08:43 AM
Multi pick into database Sacco7 Excel Worksheet Functions 0 November 5th 04 04:13 PM


All times are GMT +1. The time now is 04:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"