Since I don't have access to Access I'd like to try and use Excel as a very basic database tool.
two different sets of data:
(1) A list of journals
(2) A list of seminars and conferences
Every time I use a particular set of journals to market a particular
seminar or conference, I want to be able to link the two and be able to search AND sort on these later on.
example, I have Journal A, Journal B and Journal C.
I have seminar x and no that I used journal A and journal C
for placing an ad. So I add this to the Excel database.
Later, someone wants to find out which journals we used
for marketing seminar x, so goes off and does a search. Search comes back and says journal A and C.
Of course as
I go on other seminars are also going to be using journals A and C, so another relationship needs to be created and so on.
I'd also like to be able to search on more than one seminar at the same time and produce one list of journals at
the same time.
Finally, I'd also like to be able to perform the above in reverse, so look for a journal(s)
and find what events were marketed with them.
Sorry about the longwinded explanation.
Any help much
appreciated as always.
P.S. I AM A NEWBIE TO EXCEL