Cancelled

Create Excel Workbook With Visual Basi

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 basi excel, visual basic programmer job, sample job listing, excel programmer job, excel macros need programmer, visual, vb excel, local listing, job visual basic, excel visual basic, excel service, excel extra programmer, excel design, data visual, sheet excel job, macros excel basic, sample visual basic excel, visual basic excel post, sheet excel visual basic, custom delimited, excel split sheet, txt file import excel, sample design workbook, comma fix, excel split

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

Project ID: #1105517

2 freelancers are bidding on average $130 for this job

PG89

Hi, Please check PMB

$60 USD in 1 day
(2 Reviews)
1.6
iyempandian

interested to do

$200 USD in 4 days
(0 Reviews)
0.0