Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default Comparing Data in a worksheet and access.

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
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
Comparing Data and Updating a worksheet rbiggs Excel Discussion (Misc queries) 0 December 12th 06 12:52 AM
Data Access Efficiency: Arrays versus Worksheet Data Neal Zimm Excel Programming 2 October 2nd 06 08:39 PM
Comparing & Retrieving Data From other worksheet cba321 Excel Programming 0 November 4th 04 09:32 AM
Excel Vba - Comparing 2 ranges of data and displaying result in another worksheet wuming[_11_] Excel Programming 4 July 14th 04 07:44 AM
Help on comparing two data on two worksheet kphan78 Excel Programming 1 April 1st 04 10:08 PM


All times are GMT +1. The time now is 08:34 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"