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.
|