People are generally unwilling to open docs from people they don't know.

You should be able to find something here

http://www.mvps.org/dmcritchie/excel...tm#pivottables

"danison" wrote in
message ...

Hi

Have tried everything however cannot make this model work. I want to
have a column showing rental $ in one row, followed by Expenses on the
next row with the itemised category of expense under it. In columns,
each respective property is shown so that easily it can be seen the
rental and expense for each property. I then wish to be able to put in
calculations to show the net result for each property & overall as a
total.

If the attached zip file cannot be opened please let me know and I will
repost

Thanks everyone

Bill


--
danison
------------------------------------------------------------------------
danison's Profile:
http://www.excelforum.com/member.php...o&userid=10098
View this thread: http://www.excelforum.com/showthread...hreadid=490480