I'm sure this question has been asked/answered, but I could not find an
clear answer. Hopefully someone has a magic formula for me! Here is
my situation:

I have 3 properties that have 4-7 tenants. I've created workbooks for
each property and each tenant has a separate sheet within the workbook.
On the sheet, I have general lease info and a rent payment schedule. I
also have to keep track of deposits made for the bookkeeper and 99% of
the deposits are rent checks and have made a separate sheet within the
workbook for that. Is there a way to link the sheets so that when I
put in a rent payment, it automatically populates in the bank deposit
sheet? And is there a way to run a report to show which tenants have
paid rent for the month?

I'm trying to set up a system that will keep duplicate entry to a
minimum and at the end of the year, I can just print up sheets and hand
them to the bookkeeper to prepare the taxes. Any help is much
appreciated!

Thanks,
Nadia


--
nzatmj
------------------------------------------------------------------------
nzatmj's Profile: http://www.excelforum.com/member.php...o&userid=23572
View this thread: http://www.excelforum.com/showthread...hreadid=525351