PDA

View Full Version : [SOLVED] Export column script



elmnas
02-24-2015, 02:27 AM
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
02-26-2015, 02:48 PM
Is this question not also included in your thread?"Copying specific cells to a new sheets also give sheetname"