Excel Data

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   Buyer Rating: (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
Job Type:	Excel Visual Basic
Database:	(None)
Operating system:	(None)
Bid count:	3
Average bid:	$ 30