Group many columns to single column and make subtraction

Helo everyone

I have two files in txt format A and B:

- File A contains values one below the other (391values).

- File B contains array values with 17 columns and each column contains 23 values (the values separated by a colon).

I would like a batch process that allows:

- For file B: copy the columns one below the other to form a single column

- The output file: a txt file contains the subtraction result between the column in A file and the resulting column in B file.


This operation will be repeated for several files.

If you can supply example files, this would be a lot easier to understand

Hi,

after reading the top page yellow banner attach your source files and the expected result file …

Hi
try

Please Login or Register  to view this content.

Originally Posted by mohadin

Hi
try

Please Login or Register  to view this content.

I have this error : Runtime error '13' type incompatibility

Originally Posted by truk2

If you can supply example files, this would be a lot easier to understand

you can see the attachments file at the top.

Try This as per your attached

Originally Posted by mohadin

Try This as per your attached

Still the same error
Runtime error '13' type incompatibility
in this line : x(i) = xa(i) - xb(i)

Try

Please Login or Register  to view this content.

1) Don't quote full post, unless you really need to do it. The forum doesn't like it.

2) What do you mean by "batch process"?

Originally Posted by jindon

1) Don't quote .....

To modify it to repeat the action on several files: 1A, 2A, 2A ... etc 1B, 2B, 3B ... etc .... and then save the output .

Too vague...

Output in a workbook or multiple workbooks?
If one workbook, how?

Upload 2 sets of text files and the result that you want.

Originally Posted by jindon

Too vague...

Output in multiple workbooks
A1 with B1 to workbook 1
A2 with B2 to workbook 2 ..
......
etc
for fifty pairs of files

Please Login or Register  to view this content.

Shut down my pc already.
Will be sometime tomorrow, hopefully.

ok ..thanx again.

If further change needed, do it for yourself before you ask.

Please Login or Register  to view this content.

Originally Posted by jindon

.....

Thanx jindon
I am a beginner with the vba...does the last code exclude the seven lines of each input file (header)?

I'm only working with the files that you uploaded.

If you can not adjust it, why didn't you upload the files that you are really working?
Make dummy data with the correct format, so that I can write.

It will just a wasting time for both you and I.

Originally Posted by jindon

...

My objectif was to simplify the question .
The attached files are headed, but the data to be processed starts from line number eight.

My objectif was to simplify the question .

Then the reply will be very simplified, so you MUST adjust it for yourself.

Originally Posted by jindon

Then the reply will be very simplified, so you MUST adjust it for yourself.

If I knew programming, I wouldn't ask a question here .... I'm not a specialist
Anyway thanks

Remember all the member here are helping people as a volunteer, so we don't HAVE to help you, if you don't want to be clear.

Good luck anyway.

Thank you for your attempts...

According to your last attachment join at least a filled expected result workbook …

Hi Marc L
I have fixed the problem manually I have another challenge ... you can read this question.
https://www.excelforum.com/excel-gen...ml#post5234571

Originally Posted by geofad2000

I have fixed the problem manually

As there is an easy way just using Excel basics like any Excel beginner can operate manually …

I will do... thanx for response0