reoroman
asked on
macro for excel
Hi,
on the link bellow Attaches is two excel files in rar format , names train and test, which I need macro for both of them to make filtering on the last column which is v43 (data class), so that I can export any numbers of records based on the v43 (data class),
There are 5 classes in the last column which are (Normal, DoS, Prob, R2L, U2R).
Check the attached picture of the outcome work.
http://www61.zippyshare.com/v/57880067/file.html
so
Thanks
what-i-need.png
on the link bellow Attaches is two excel files in rar format , names train and test, which I need macro for both of them to make filtering on the last column which is v43 (data class), so that I can export any numbers of records based on the v43 (data class),
There are 5 classes in the last column which are (Normal, DoS, Prob, R2L, U2R).
Check the attached picture of the outcome work.
http://www61.zippyshare.com/v/57880067/file.html
so
Thanks
what-i-need.png
ASKER
no, another job now...that will be after this..it is the same as the previous work where the output was numbers, here the output is text.
ok let me see it and will revert
I see here you want to sort by AP but still you have a column AQ that is also used, need to know if we also need to add an extra column to put Y when you transfer so it does not transfer the same record twice ?
gowflow
I see here you want to sort by AP but still you have a column AQ that is also used, need to know if we also need to add an extra column to put Y when you transfer so it does not transfer the same record twice ?
gowflow
ASKER
I want to sort by AQ only. and i need you to put additional column for Y so it does not transfer the same record twice. thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
works fine, but please delete the renumber classes icon.
I need two macro one for train and one for test, OR you teach me how to change the macro to read any file name i need it to.
I need two macro one for train and one for test, OR you teach me how to change the macro to read any file name i need it to.
ASKER
can i do it by going to
Set WSTR = Sheets("Test")
and change it to
Set WSTR = Sheets("Train")
Set WSTR = Sheets("Test")
and change it to
Set WSTR = Sheets("Train")
yes exactly. and for renumber jus delete the button renumber
to do this before activating macros u can delete the butotn
gowflow
to do this before activating macros u can delete the butotn
gowflow
ASKER
Professional work, As usual.
Thanks a lot.
Thanks a lot.
Your welcome, my pleasure. Pls feel free to post a link here if you need anymore help.
Rgds/gowflow
Rgds/gowflow
ASKER
yes, sure thing
By the way I have ready your previous request on duplicate rows if and when let me know.
Also I was very surprised to notice that the file which had some 500,000 records after running the macro came down to only 10% of it 50,000 is it normal that you had so much duplication ?
gowflow
Also I was very surprised to notice that the file which had some 500,000 records after running the macro came down to only 10% of it 50,000 is it normal that you had so much duplication ?
gowflow
ASKER
hi, i am posting the question now.. i will be back with the link.. Thanks
ASKER
gowflow, are you there ?
gowflow