I gang

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.

Færdigheder: Excel, Visual Basic

Se mere: xls header, pay data, me excel, vba split excel data, excel split file vba, vba split separate excel, n excel, excel split columns, master excel, urgent need excel, urgent excel, master data, job visual basic, future choice, excel visual basic, excel job, excel based, do excel, data visual, bs, excel split data sheets, excel contains, separate excel data sheets, split file, xls visual basic

Om arbejdsgiveren:
( 15 bedømmelser ) Norman, United States

Projekt-ID: #253781

Tildelt til:


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 på 1 dag
(13 bedømmelser)

3 freelancere byder i gennemsnit $30 for dette job


Please read PMP.

$30 USD in 2 dage
(0 bedømmelser)

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

$30 USD på 1 dag
(0 bedømmelser)