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.
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.