Excel Manipulation

I have 100+ Excel files. I need to extract column and row data from these files, write the data to another file, and save the new file as "values". All this done in a batch process using the original files. The new files could be in another directory with the same filename as the original. There exists some combination of columns to create one new column in the new file. The original files shall remain unaffected columns A thru BN. I don't care if more columns are added to make the effort easier.

In short:

1) place original Excel files in a directory.

2) run this program I'm asking for.

3) have new Excel files with exactly what I need.

Attached is a file that might help explain...

Columns A thru BN are the columns in the original file. The columns are consistent but the column labels are not. In other words - don't use the column labels.

Columns BP thru BU are the columns I need in the new file - saved as values rather than formulas. Please see the notes below the columns.

The reason for the "spoofed" example data is that this data is sensitive to my company. The original files contain hundreds of rows each.

$50 is my entire budget for this first cut. There is a go between step that I have to do manually before I post another very similar project. Thank you for any consideration of this project.

Beceriler: Excel

Daha fazlasını gör: excel file data manipulation, new excel, extract excel files, excel row column, batch batch excel file, excel column row, extract filename, write file excel, column row excel, extract data excel files, batch file post, create excel formulas, excel combination, file manipulation program, excel manipulation, excel contain, batch process, excel files directory, program program excel, excel program write, excel row columns, excel file save file, file directory excel, 100 excel, formulas excel

İşveren Hakkında:
( 17 değerlendirme ) Spring City, United States

Proje NO: #4447147



Consider it done. Check your PM for my bid details.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(49 Değerlendirme)

8 freelancers are bidding on average $44 for this job


Hi, I am scraping expert, More details in PM.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(31 Değerlendirme)

Please check PMB

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(17 Değerlendirme)

Hi there, Its my pleasure to work for you. Lets start asap.... regards

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(18 Değerlendirme)

Sir, I can do this job. Please check PMB

in %bids___i_period_sub_35% gün içinde34%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

Hello, I can help you. thanks

in %bids___i_period_sub_35% gün içinde44%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

Sir, Please give me this project to me. I will complete it soon.

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Kindly check your PM....

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hello, we are ready to start the project as soon as you consider. For further details about biding please see Message.

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)