I have created a large excel spreadsheet with information about all monetary
donations received. This report is for my records. I have also created a
gift notice (with less information) in excel for another audience. I would
like to know how to populate the gift worksheet while entering info on the
main worksheet.

The description you've provided is so skeletal that we can only guess at what
you want.

Do you know how to link a cell in one sheet to one in another?
How do you determine what information in your large spreadsheet will be
shown in the smaller sheet?



"NKirkland" wrote:

I have created a large excel spreadsheet with information about all monetary
donations received. This report is for my records. I have also created a
gift notice (with less information) in excel for another audience. I would
like to know how to populate the gift worksheet while entering info on the
main worksheet.

I have never worked with linked worksheets . I apologize for being unclear.

I use the large worksheet as a database to track all donations received and
I create thank you letters to the donors from it using a merge document.
However, their is a gift sheet.xls that must be populated with only the name,
address and amount of gift that is created specifically to go to accounting
with the check. Accounting does not need all the information in the
database. I am trying to avoid typing the same information more than once.

I hope that is more clear..


The description you've provided is so skeletal that we can only guess at what
you want.

Do you know how to link a cell in one sheet to one in another?
How do you determine what information in your large spreadsheet will be
shown in the smaller sheet?



"NKirkland" wrote:

I have created a large excel spreadsheet with information about all monetary
donations received. This report is for my records. I have also created a
gift notice (with less information) in excel for another audience. I would
like to know how to populate the gift worksheet while entering info on the
main worksheet.