Relative/Absolute References Across Files

MonaExcel

New Member
Joined
Oct 15, 2002
Messages
1
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?
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

maxflia10

Well-known Member
Joined
May 20, 2002
Messages
890
Mona,

By using a link =a4, when a row is added above it, it will change to =a5. Anything below will not change. So it will display the original linked information. Using $ will not do any anchoring.

If you want to "anchor" the reference use INDIRECT(a4). But this takes a lot of memory
This message was edited by maxflia10 on 2002-10-16 19:47
 

Forum statistics

Threads
1,144,312
Messages
5,723,654
Members
422,508
Latest member
Lordkit1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top