GetAFreelancer.com
 
Find projectsSearch
Sign Up | Log in | Top Rated Users | Browse projects | Post Project | RSS feeds | Articles
 

Excel Data

   Click here to post similar project

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

Status: Closed (Selected Service Provider)
Selected Providers: selected service provider SergeyPlus
Budget: $30-250
Created: 04/23/2008 at 16:28 EDT
Bidding Ends: 04/25/2008 at 16:28 EDT
Project Creator: sumanbasuroy View PM Post PM
Buyer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(9 reviews)
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
Report violation
Job Type:
  • Excel
  • Visual Basic
Database: (None)
Operating system: (None)
Bid count: 3
Average bid: $ 30

 

Related project
 
Unique Picture Programming Project Featured
posted by CAllen626
Budget: $1500-3000
 

FREE Trial project for new buyers!

 

View Project Message Board     Post Message on Project Message Board
Messages Posted: 0

If you are the project creator or one of the bidders Log in as project creator or bidder for more options

Bid on This Project

Service Providers PMB Bid Delivery Within Time of Bid Provider Rating
SergeyPlus
View PM Post PM
$ 30 1 day 04-23-2008 17:26 EDT 9.92/109.92/109.92/109.92/109.92/109.92/109.92/109.92/109.92/109.92/10
(13 reviews)
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.
pbsinfotech
View PM Post PM
$ 30 2 days 04-23-2008 17:09 EDT 9.00/109.00/109.00/109.00/109.00/109.00/109.00/109.00/109.00/109.00/10
(1 reviews)
Please read PMP.
esperarpaga
View PM Post PM
$ 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.
Bid on This Project

 

[ EU Freelance ] [ Join GAF Free ] [ Post Project Free ] [ Web Forms ]

What is GetAFreelancer.com? ( Read about the company )

GetAFreelancer.com is one of the largest sites of its kind. We have earned a good reputation and you can trust us. Deposit money and don't purchase until your project is completed. Outsourcing is hiring an outside organization to perform services such as information processing and applications development. Would you like to outsource your next project? Would you like to make money as a freelancer? Click Sign Up to start! If you never tried to contract work to another part of the world you have your chance today. Sign up free! We have thousands of satisfied clients around the world.

A freelancer is an independent worker, not on salary, hired instead on a project basis. Buy services with help from our secure escrow system. Outsourcing is the process of subcontracting network operations and support to an organization outside your own company. Try it free today! We provide a safe escrow environment and you don't release the money until project is completed. Our mission is to find the best possible freelance workers at the best possible price.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.