PC Review


Reply
Thread Tools Rate Thread

Comparing Data in a worksheet and access.

 
 
=?Utf-8?B?S2V2aW4gUG9ydGVy?=
Guest
Posts: n/a
 
      13th Feb 2007
I need to open an access database (which only has employee name and store ID)
Compare the name in E1 (then f1, then g1 and so on) see if the name is in
the database, if it matches, then look at the store ID from the database and
write that column into a specific worksheet based on the Store ID.

I have found lots on writing into this or that, but nothing as far as
comparing.

Thanks.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing pivot tables entries with data in another worksheet Iain M Microsoft Excel Programming 0 26th Nov 2007 09:53 PM
Comparing Data and Updating a worksheet rbiggs Microsoft Excel Misc 0 12th Dec 2006 12:52 AM
Comparing & Retrieving Data From other worksheet cba321 Microsoft Excel Programming 0 4th Nov 2004 09:32 AM
Excel Vba - Comparing 2 ranges of data and displaying result in another worksheet wuming Microsoft Excel Programming 4 14th Jul 2004 07:44 AM
Help on comparing two data on two worksheet kphan78 Microsoft Excel Programming 1 1st Apr 2004 10:08 PM


Features
 

Advertising
 

Newsgroups
 


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