Devam Ediyor

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ün: excel file data manipulation, new excel, extract excel files, excel row column, 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, excel program write, excel row columns, file directory excel, 100 excel, formulas excel, program extract data excel, words combination program, explain excel

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

Proje NO: #4447147

Seçilen:

Teloquence

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

1 gün içinde 50$ USD
(49 Değerlendirme)
5.2

8 freelancer bu iş için ortalamada 44$ teklif veriyor

mantislin

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

1 gün içinde 54$ USD
(31 Değerlendirme)
5.5
srikartiram

Please check PMB

1 gün içinde 43$ USD
(17 Değerlendirme)
4.0
mandeeps207

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

in 2 gün içinde50$ USD
(18 Değerlendirme)
3.9
ideadezigner

Sir, I can do this job. Please check PMB

in 3 gün içinde34$ USD
(2 Değerlendirme)
3.2
wbslivera

Hello, I can help you. thanks

in 0 gün içinde44$ USD
(2 Değerlendirme)
1.2
dinalkc

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

in 3 gün içinde45$ USD
(0 Değerlendirme)
0.0
diligent123

Kindly check your PM....

in 4 gün içinde35$ USD
(0 Değerlendirme)
0.0
globalbyte

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

in 2 gün içinde45$ USD
(0 Değerlendirme)
0.0