Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Data and Updating a worksheet | Excel Discussion (Misc queries) | |||
Data Access Efficiency: Arrays versus Worksheet Data | Excel Programming | |||
Comparing & Retrieving Data From other worksheet | Excel Programming | |||
Excel Vba - Comparing 2 ranges of data and displaying result in another worksheet | Excel Programming | |||
Help on comparing two data on two worksheet | Excel Programming |