Macro to select last used column+1

[excelhelpseeker]

Hi champs,

I have a report from which output is extracted.


three inputs are to be saved in D:/test/ and from report file-list tab, output is extracted from RUN button.

see output in output tab... and need a code to extract output mentioned in "correct output" tab

find attached sample files for reference.

[Alf]

Perhaps something like this, must admit macro a bit more complicated than it needs to be.

Alf

[excelhelpseeker]

Thanks a ton for the code.....works excellent

[Alf]

You are welcome and thanks for feedback

Alf