Greetings everyone....here's my issue. I have series of data for each vacant apartment in the community I manage. My resident management software spits this excel-based 'unit pricing report' out every morning. Problem is, it is not user friendly, is difficult to read, and contains a lot of information that me and my staff don't need in the leasing process.
So, my idea is to create a template i can copy and paste this data into each day that will reformat it into a more legible and logical manner. The number of vacant units vary from day to day so the worksheet will need to calculate this. I think this is largely where I am getting confused. I have attached what I have so far. The first worksheet is the raw data that will be "uploaded" everyday. The second is the formatting I would 'prefer' for it to have. If I'm venturing into VBA territory to solve my problem thats ok. I have some basic VB.net training, someone just let me know and I will repost this in the proper Forum section
Thanks in advance for any advice!!!
-JR
Bookmarks