Excel Data

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 [url removed, login to view] as an example. I have done this manually. Similarly, [url removed, login to view] 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.

Skills: Excel, Visual Basic

See more: xls header, pay data, me excel, excel &, excel split file keep header download experts exchange, vba split excel data, excel split file vba, split excel file empty row, xls split file sheet macro, vba split separate excel, n excel, how to master excel, excel split columns, master excel, Visual Basic Excel, urgent need for excel, urgent excel, master data, job visual basic, future choice

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

Project ID: #253781

Awarded to:


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.

$30 USD in 1 day
(13 Reviews)

3 freelancers are bidding on average $30 for this job


Please read PMP.

$30 USD in 2 days
(0 Reviews)

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

$30 USD in 1 day
(0 Reviews)