I am creating a database to track contributions. The source file is a simple list of contributors and their monthly contributions for the year. This file is used for ease in recording the donations. Every month I receive a report from our headquarters office indicating the donations. From this report I record the donations on the source file. Each year is stored on a separate worksheet within that file.
The database (or what I call a database) is a separate file that has a worksheet for each contributor. The contributors' donations are linked from the source document. Each contributor's worksheet shows the amount given for several years, along with other pertinent contact and mailing information.
My Question: I am continually adding new contributors to the source file. Since this list is kept alphabetically by city, rows have to be inserted. I am having trouble knowing whether to use the absolute cell reference or leave it as a simple link. I have tried several options. Sometimes the absolute reference works and at other times it does not. What am I doing wrong?
The database (or what I call a database) is a separate file that has a worksheet for each contributor. The contributors' donations are linked from the source document. Each contributor's worksheet shows the amount given for several years, along with other pertinent contact and mailing information.
My Question: I am continually adding new contributors to the source file. Since this list is kept alphabetically by city, rows have to be inserted. I am having trouble knowing whether to use the absolute cell reference or leave it as a simple link. I have tried several options. Sometimes the absolute reference works and at other times it does not. What am I doing wrong?