Suoritettu

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

Tietoa työnantajasta:
( 15 arvostelua ) 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 %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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 [login to view URL]

$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 [login to view URL] my exam is [login to view URL] i have much time for doing this [login to view URL] i have 2 years exprience about this project and my typeing spead is [login to view URL] 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