Project Detail

Excel Data  

Excel Data is project number 253781
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: SergeyPlus

Budget: $30-250

Created: 04/23/2008 at 16:28 EDT

Bid Count: 3

Average Bid:
$ 30

04/25/2008 at 16:28 EDT

Project Creator: sumanbasuroy
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (11 reviews)

Bid On This Project
 

Description

I need a very small job done. I want a Visual Basic program to be written to split my Master excel file into separate files.
Each split file should contain columns A-E. And one of the columns F through BS.
Consider column F in the "Master" file. Its header is "101". Several rows of this column are empty. I want a separate excel file for "101" that only contains columns A thru E and F with all empthy rows DELETED. See 101_final_sem_08.xls as an example. I have done this manually. Similarly, 102_final_sem_08.xls retains columns A thru E + column G from Master file, with all empty rows deleted.

I know one can do this manually. But I will be manipulating these again and again with different numbers in future in the rows under F thru BS. So I need you to write me a program that I can run on the master file and split it into 232 separate excel files. Visual Basic is the preferred choice so that I can run it on Excel. So your program needs to do 2 things:
1. split the master file into 232 separate excel sheets, each file containing columns A thru E and one of the columns F thru BS.
2. Based on the last column in each file, your program should delete ALL empty rows for for that column.
3. At the bottom of each columns F thru BS there is a total - that should remain there.

You will give me the program with some instructions as to how to run it + 232 separate files for this job.

I will pay $30 for this job.

This is urgent. Bid ONLY if you know Visual Basic and you are confident that you can do this.




Additional files submitted:
Master_final_sem_08(1).xls
101_final_sem_08(1).xls
102_final_sem_08(1).xls

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

30

1 day

04-23-2008 17:26 EDT

Hello. I can do it for you in 1.5 hours. After I see you have chosen me. Sergey S. See PM for a question please.

help

 

30

2 days

04-23-2008 17:09 EDT

Please read PMP.

help

 

30

1 day

04-23-2008 17:19 EDT

(No Feedback Yet)

I will do your work with a macro, then you can use it using only Excel.

help


    Bid on this Project