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.