Hi,

I will run another calculation (slightly different) on the basis of the code provided by you (hopefuly) and the results will go into the new file C1, C2, C3, etc., then I will
just make some basic calculations between columns B and C directly in the new file.

I am not sure whether I understand correctly the second question, do you want to know whether the calculation from the original file from N2 may go into the same original file in column B?
It will not work for me, because there is over 50k files in the whole folder (divided into 500 subfolders) and I need to extract the number from cell N2 from every single original file and put it
into the new (one) file, thus I would be able to make some calculations inside just this one new excel, but I would have information from the whole folder.

I hope I clarified it a bit, if you need to know more, do not hesitate to ask. And once again I really appreciate your help, thank you very much!

Kind regards,

M