I don't know if anyone uses Argus here (its a real estate program) but I am trying to take the data dump from Argus and load it into a readable excel format. I can export all the data and get it to excel, but can't figure out how to format this.
Basically, the Argus dump lists all tenants in a building and money spent by the landlord (me) each by month to fix up their space:
Jan Feb March
Tenant A $100 $0 $25
Tenant B $0 $50 $100
Now I want to convert this into a format that lists:
January
$100 Tenant A
Feb
$50 Tenant B
March
$25 Tenant A
$100 Tenant B
We have sometimes over 100 tenants in a building and the months change all the time so I need a standard dump page and then a page that lists each tenant dollar amt spent by month. I only want it to grab the tenants name and dollar amt if its greater than zero.
Thanks
Bookmarks