View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W.R.[_2_] J.W.R.[_2_] is offline
external usenet poster
 
Posts: 1
Default Using Excel as a data base

I am using excel as a data base. It is very large What I am trying to do is
from word I want to look for specific data lets say like AD-02.56 then find
all the matches in the database and return the row that contain the serch
data i am lookingf for. it could be up to 20 rows that may have that data.
Is there a book that I can look for that can help me out in writing the macro
or what ever i will need to pull the information from excel into the word
document? I have 8 colums of information and like 500 recorde (rows) and so
on. I am just looking for a good book to get started on how to use excel as
a database.

Thank you for you help.

J.W.