Export column script

[elmnas]

Hello guys

I need help to create a script thats

copy first the name of the open filename + the name of the open sheet also looking for the word SV in the first sheet (it's always on the first row somewhere)
take the whole "SV"column copying to a new excel on the same place saving the file on the same location
example

I have opened the file:test.xlsx (location:\desktop\test.xlsx)

the file contains following sheets(cat,dog,bird)

columns on the first row are (FIN,SV,ENG)


result:

test_cat_SV.xlsx

the file contains the column SV on the same place with all data from the column too


Could someone help me out?

Thank you in advance

Best Members,

[Yongle]

Is this question not also included in your thread?"Copying specific cells to a new sheets also give sheetname"