Hello,

I have 2 worksheets. One with historical rents: it has 5 columns:

A B C D
E
Store # active rent Monthly Rent Rent Start date
Annual rent
1 500 active 1,734 5/9/2003
20,809
2 500 active 2,365 6/1/2003
28,376
3 500 active 2,512 6/1/2008
29,263
4 501 active 4,411 3/4/1998
52,936


The second spreadsheet is organized like an income stmt with monthly
financial data.

if i change the store # in cell D4, it will update the entire sheets income
stmt showing financial data for the entire sheet. i'm trying to show
historical rent, so it will show rent that was paid that month... currently
whenever i change the rent, from the sheet that has the current rent it will
change everything in the past, so i just want it to show the actual rent that
was paid.

Any help would be great!

Thanks!

David