In Progress

Create Excel Workbook - Visual Basic

I have an excel workbook that I've created to perform calculations for real estate markets. I download the data from a local listing service and then import it into my excel workbook. I then must manually separate the data and fix errors like blank values in cells. I need a Visual basic programmer to design the workbook to work more efficiently using VB macros and ensure that all the calculations are correct.

I've completed some of the calculations already to give you an understanding of how I want the data presented. It also gives you an understanding of what all the abbreviations in the TXT file mean.

Here is how the excel workbook should work:

1) There will be an extra button added to the toolbar. Upon clicking this button, you are prompted to select a txt file (comma delimited) to import.

2) The program then prompts for a date to be input. You can input a custom date or use current. This date transfers to cell H1 on the "Calcs" sheet and is the date used for all calculations.

3) After inputting a date the file is imported and the data is automatically split into the two worksheets "active" and "sold" based on their status.

4) All calculations on the "Calcs" sheet are completed and accurate.

I've attached the workbook and a sample txt file that I will be using to import. If you have any questions please post them PRIOR to accepting the job.

Skills: Excel, Visual Basic

See more: visual basic create excel workbook, visual basic excel post, visual basic create excel sheet, visual basic programmer job, vb programmer job, sample job listing, need of excel programmer, job vb programmer, i need a visual basic programmer, i need a basic programmer, excel programmer job, excel macros need programmer, create excel visual basic, use visual basic excel, vb in excel, excel split a cell, visual, Visual Basic Excel, vb excel, local listing, job visual basic, import excel, excel visual basic, excel service, excel extra programmer

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

Project ID: #1105539

Awarded to:

mfernwood

Details laid out in PM.

$90 USD in 0 days
(2 Reviews)
2.8

29 freelancers are bidding on average $79 for this job

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$100 USD in 5 days
(64 Reviews)
6.5
koolsidz

Please see PMB

$88 USD in 0 days
(101 Reviews)
5.8
FIBIN

Hi I am an expert in Excel and VBA Programming in Excel. I have experience in Excel Designing, Excel VBA Programming, Providing Business Solutions in Excel and Creating Dashboards in Excel for Presentations. I am i More

$30 USD in 1 day
(42 Reviews)
5.3
gshiels

Please see PM

$100 USD in 2 days
(11 Reviews)
4.9
imudita

Please see my PM.

$50 USD in 2 days
(29 Reviews)
4.7
chriskerpini

Please check PM.

$50 USD in 1 day
(12 Reviews)
4.4
stacross

we'd like to bid on your "Create Excel Workbook - Visual Basic" project. Refer to PM.

$100 USD in 0 days
(17 Reviews)
4.1
ExactSystems

Please see a better solution on PMB. regards

$195 USD in 5 days
(4 Reviews)
4.1
muthumuni

………..#####... “KINDLY FOLLOW MY MASSAGE & FEEL REAL DIFFERENT HERE” ...##### ……….. .

$30 USD in 2 days
(11 Reviews)
3.8
gurnit

Give me the website (local listing), I will eliminate the need for importing the txt file, my macro will go to the website, import it in the background for the date entered in cell H1. I will show you the demo video on More

$30 USD in 0 days
(2 Reviews)
3.4
cheungkc

Hi Detailed proposal in PM please

$50 USD in 3 days
(7 Reviews)
3.0
Paranos

I am a US based consultant with immediate availability to work on your project. I look forward to working with on this project and would consider this a trial run for future business. Please see PM for details regards, More

$130 USD in 1 day
(1 Review)
2.1
PG89

Hi Please Check PMB

$50 USD in 0 days
(2 Reviews)
1.6
anatprog

I can do it

$100 USD in 5 days
(0 Reviews)
0.0
prolancer7

I can do this.

$70 USD in 10 days
(0 Reviews)
0.0
Adisehgal

Please check PM

$50 USD in 2 days
(0 Reviews)
0.0
AltESV

I perform this type of work every day. I can complete this job for you.

$100 USD in 3 days
(0 Reviews)
0.0
manojkjoshi2010

I am an experienced vba programmer and doing the same from last 4 years have done many such projects.

$85 USD in 2 days
(0 Reviews)
0.0
riteshmehta

Ready to solve this... i love vb,macro.... programming

$40 USD in 1 day
(0 Reviews)
0.0
mask123

Dear Sir, our firm is the right place to satisfy your [url removed, login to view] of the team members is expert in .[url removed, login to view] completed a lot of works in .net (windows application &web application).Examples of web applicati More

$50 USD in 5 days
(0 Reviews)
0.0