Tweek the code

[Dinesh_Excel]

Hi Friends,
Require your help for the below output as explained below using VBA.
Also attahced sheet for your reference

 

[Marc L]

Hi !

What a weird idea to join an empty file !

Easier to understand with before and after worksheets …
​

 

[vletm]

Click [OUPUT], Cell[AB1] to get 'values' to column [AB].
You will get ...
Remember that conditions are sensitive, like 'a' is different than 'A'.

About 'Read me'-sheet:
Try to do Your report few times with Your instructions.
For example, after row 3, Your report will have a lot of text like " 1"
You should record Macro and after that You could get 'better version of it'.