I have a Macro-Enabled 2007 Excel Template that I need some help with. You can view the template here: [url removed, login to view]
You can view a video of how I use the template here: [url removed, login to view]
The purpose of the template is to take data from a text file and produce calculations for real estate. The data being used in from the sales of homes in an area over the past five years, and any active listings on the market.
Currently the issues is that I have the data separated yearly because I do not know how to make the calculations based off a set date. For instance, if the date of my report is 3/15/2009, i do not know how to program the template to KNOW that data from 3/15/2008 is a year old.
Also, I need a macro programmed that will automatically fill down fields with a formula.
I also need the formulas to ignore Zero values in certain fields so that zeros are not included in the Lows or Averages on the report page.
As discussed in the video, if the project completion is good, then there will be future work with this project including a possible web application created from it.
20 freelanceria on tarjonnut keskimäärin 94 $ tähän työhön
Dear client, I am a computer science graduate. I have good experience in excel and right now i am working in freelancer projects. I am very interest to do this project. Waiting for your reply.Thanks
Hi sir my profashion is office work and i am do these types work daily on my office and i have a lot a time to free because i will do work early so give me this work so see i u feel comfertable. Thanks
dear sir, i am a student.recently my exam is finished.so i have much time for doing this job.otherwise i have 2 years exprience about this project and my typeing spead is 30-35.so i hope that you give me this project.