linking 2 spread sheets

[Guest]

This is a dumb question. I use an exel spread sheet for a mail data base,
(news letter).
I make mailing labels through word. Then use that data to mesure the
response.
When I send out a news letterI give coupons out. I track the ones that are
redeemed.
I'm entering the redeemed info for the mailing on one sheet , then entering
the same info on my main database.(to see total amount of coupons redeemed
for each customer.) how can i link when I enter the redeemed date = amount
from one to the other?

 

[Debra Dalgleish]

To enable someone to suggest a way to link the data, you should describe
the layout of each sheet and the data that's entered.

For example, what are the column headings? Is there a unique customer
number that could link the data? How are the coupons identified?