Search results

  1. J

    HELP about split !!

    great :) ~ thanks so much for your help :) now I have this table in a collection. how to turn them into a collection where each of the country is in a row ? because after that I will need to use loop to pick up each country 1 by 1.
  2. J

    HELP about split !!

    oh , then we prefer to follow your recommendation to create a list of all possible countries. after that, how to do in order to delete those countries/cities not matching with this list? :)
  3. J

    HELP about split !!

    @sahil_raina_91 thanks a lot for your kind help :) it still remains the cities like shanghai, bangkok, taipei ... Is there additional step to filter or pick up only country names?
  4. J

    HELP about split !!

    @shikhar.mishra yes correct. :) appreciate your help ... sharing the steps (in blue prism) to do this. result is that a collection that cell contains only the country names.
  5. J

    HELP about split !!

    @VJR could you pls help? :)
  6. J

    HELP about split !!

    hi guys, could you pls help me this :) I would like to get only country names (if any duplicate names, any city names ...are not selected, and South Korea or Korea it will pick up Korea only...) from this cell. How should we do that? Expected result : have a collection with this column where...
  7. J

    How to delete columns in a collection

    okay thanks for sharing :)
  8. J

    open file names from excel file

    oh yeahhh it works :) thank you ;)
  9. J

    open file names from excel file

    hi bro :) I put only A2, and it works, but only for the 1st loop the 2nd loop, it overwrites the first paste and start at A2 again :(
  10. J

    open file names from excel file

    hi bro :) after I change to : "A2" & [Last row file1] it becomes cell A21 because the destination file 1 , initially we have 1 header row, and the value counted is 1. putting "A2" & [Last row file1 , this becomes cell A21 the data is pasted starting at cell A21 onwards :(
  11. J

    open file names from excel file

    hi bro, i want to keep the headers in the destination file ... so, the destination range will be revised how ?
  12. J

    open file names from excel file

    hi bro : ) i try again , it works, but it pasted overwrite the first row also :( which is all the column headers now overwritten and become the 1st row of pasted data :(
  13. J

    open file names from excel file

    hi, could you please help advise the error is at which stage and what to put in source range and destination range ? :(
  14. J

    open file names from excel file

    oh noooo... : ( I try to run and the copy paste of the 2nd File overwrite the first copy paste action : ( it's not continued from the last row of the first file copy paste : ( how to fix it ,,, : (
  15. J

    open file names from excel file

    hi bro, about close workbook, this is not close instance right? and so the workbook I should close are those file 1, file 2 ... when the loop open them ?
  16. J

    open file names from excel file

    also, the Get number of row, I put this stage before the copy past range right?
  17. J

    open file names from excel file

    hi bro how about the source range and destination range, what I should put ?
  18. J

    open file names from excel file

    hi bro how about the source range and destination range, what I should put ?
  19. J

    open file names from excel file

    hi bro ! we need to use loop before we get worksheet as collection, right? (before we get worksheet as collection for all the files listed in the column of the excel file, right ? )
  20. J

    open file names from excel file

    hi bro : ) thanks a lot and let me try : )
Top