Käynnissä

Microsoft Office Excel Template Redesign

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.

Taidot: Excel

Näytä lisää: www microsoft excel formulas, www excel, Work from homes, temp work, sales temp, microsoft project template, microsoft excel formulas, i need microsoft office, i need excel help, how to know how i work with formulas on excel, excel to application, excel macro how to, c program template, application template excel, microsoft office template real estate, office excel template, word template redesign list, microsoft office excel templates, Microsoft work, microsoft macro, how to microsoft excel, excel help formula, do i need microsoft office, need help with excel, need excel help

About the Employer:
( 15 reviews ) Austin, United States

Projektin tunnus: #402066

Myönnetty käyttäjälle:

Rhadoo00

Hi. I've seen your demo and your xl. Sounds pretty simple, liked the fact you realized it's more efficient to start programming macros. This will also resolve your "zero - fields" problem. I can also make your whole Lisää

30 $ USD 2 päivässä
(0 arvostelua)
2.0

20 freelanceria on tarjonnut keskimäärin 94 $ tähän työhön

svet63

Excel developer since 1997. Can do. Regards, Svet.

100 $ USD 3 päivässä
(46 arvostelua)
6.1
imranamin

Lets Start

155 $ USD 7 päivässä
(30 arvostelua)
5.4
northwolves

As an expert of this field,I'm looking forward to working with you,see PMB please.

111 $ USD 2 päivässä
(30 arvostelua)
4.6
pyazlm

You may check PMB.

30 $ USD 3 päivässä
(30 arvostelua)
4.4
mahfuzmurshed

Please check PM.

50 $ USD 2 päivässä
(46 arvostelua)
4.1
oFAZo

Exceptional quality & fast work. Please refer to Profile and PMB for details. Thanks FAZ

100 $ USD 2 päivässä
(9 arvostelua)
3.1
jasnhelsinki

Please check PM for details

200 $ USD 1 päivässä
(7 arvostelua)
3.0
VLADNOVA

I will be glad to help. Kindly see PM for details.

245 $ USD 3 päivässä
(1 arvostelu)
1.0
sumeet00

Hi, Check PM. Thanks and Regards, Sumeet.

150 $ USD 3 päivässä
(1 arvostelu)
1.0
subhendusekhar

I am a commerce graduate. I have strong software skill in Word, Excel & Access. I am fluent in english. I have 5years of experience in the field of data processing and another 5years of experience in the field of softw Lisää

100 $ USD 3 päivässä
(0 arvostelua)
0.0
jsathish26

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 [url removed, login to view]

30 $ USD 5 päivässä
(0 arvostelua)
0.0
prabhat1607

I am expert with the Excel's all functions. I have 5 year exp, So just give challenge to me.

85 $ USD 2 päivässä
(0 arvostelua)
0.0
Nazareya

I am Excel expert and I can not see any problem to redesign this form

100 $ USD 2 päivässä
(0 arvostelua)
0.0
NeerjaBhilai

I will do it within three days. I would like to view more details.

50 $ USD 3 päivässä
(0 arvostelua)
0.0
johnyarora

HI.. I have team of VBA professional and we have designed a number of such models. This should be an easy task. As I am new to this site, price is not a big issue. WE can talk over it. Also, I can assure you of the qu Lisää

150 $ USD 7 päivässä
(0 arvostelua)
1.4
grabprojects

*** Consider it as done. Quality Guaranteed! ***

100 $ USD 2 päivässä
(0 arvostelua)
0.0
honey715

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

30 $ USD 1 päivässä
(0 arvostelua)
0.0
sharifullah786

dear sir, i am a [url removed, login to view] my exam is [url removed, login to view] i have much time for doing this [url removed, login to view] i have 2 years exprience about this project and my typeing spead is [url removed, login to view] i hope that you give me this project.

30 $ USD 2 päivässä
(0 arvostelua)
0.0
neerajrawat7004

business professional programmer for last 5 years...u will be more than satisfied with the work

30 $ USD 1 päivässä
(0 arvostelua)
0.0