Hi,

I have multiples xls & xlsx file i need to open file and pull third grouped data text row A8 and transpose paste special value to new sheet like below.

Any macro or formula can you advise.

Thanks for your views and replies.


test.png