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,
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,