Search results

I dont think there is a need to create macro to sort a collection as we already have sort action in collection.. I am looking for vba to multi sort the columns in excel. Can you help me with that

I cannot use collection, I need to do this in excel only.

hi, can someone pls help with multi-sorting in excel. for example: there are 10 columns in excel and col H, I , B, C, D, E needs to be sorted all at a time in ascending order (like first 5 in A-Z and last one in 0-9). So, how to do that? thanks

can you please help me with regex for this pattern: 123-456-7789 This particular string (10 digit number separated by -) can appear anywhere in a collection row like: <some text> <tab> 123-262-9282, APR15-MAY15. I used : (?<Name>\d{3}-\d{3}-\d{4}) but this does not works.

hi, how to keep the data in excel and removing formula. Example: there is a formula in cell range: P6:P15 and now i want to keep only data removing formula. I tried by using select > copy > paste but its giving me error: Ambiguous match found, even if there is a different data in all the cells...

I tried first solution but getting error: could not execute code stage: Ambiguous match found. I have duplicate values in that range, but that is requirement. How to fix it?

Any suggestions on this would be highly appreciated.

Thank you, I will try this. If this column list is dynamic, for example, in one process I have to just two columns and next time there can be 3, 4 also. So how this can be set dynamic

hello, how to delete duplicate rows from excel based on duplicate data in multiple columns. example: col1 col2 col3 col4 val1 val2 val3 val4 val1 val2 val3 val5 val5 val7 val8 val9 so as per above example, bot needs to look for the duplicates in col2 and col3 data only and in result, it should...

hi, i am new to mainframe automation and using blue zone session manager. I am unsure about the application type to use in application modeller, also what should i put in session file path. I see foll. in app modeller. thanks

I have more than 6K records. And I am not using collection. I need to directly do that in excel.

No, in WQ I have to add sample 1 and sample 2 file data as that is my main file which needs to be processed. The sample 1 and 2 files are being prepared from dashboard file

You can create a separate object to handle that pop-up. I too faced similar issue, please check this thread for solution - http://rpaforum.net/threads/issue-while-running-macro.14133/#post-29759

Also how can I pass the operator as user defined.. because in some condition, it is =, <> or >

Thanks Sahil. Can you also please help with this query: http://rpaforum.net/threads/cell-color-based-on-value.14148/#post-29787

hi, how to highlight the excel cells based on value present in another column or same column. Example- cola colb 25-Aug b 26-Aug c 27-Aug d 28-Aug e 29-Aug y 1. To highlight col b cells where col b does not contains text "d". So, rest all in col b to be...

hi, can someone please help with below query: i have an excel file containing large amount of data like 6K, 7K. In that, there is a column of phone number (Col B). Now the requirement is to check if there is a duplicate entry for phone number, then col C needs to be updated with notes...

hi, can anyone pls help me in implementing environment locking /multi-bot feature: 1. there are three files, one is dashboard file and another is sample1.xlsx and sample2.xlsx files. 2. Bot is pasting the data from dashboard file to both sample 1 and sample 2 files and then some excel...

Thanks, it worked.

Hi, Can anyone please help with below issue: I am running a macro in excel but there is a pop up appearing in which there is a button "done", once the macro has run. I created a separate object to handle that pop up, but issue is bot is not moving further from Run macro stage so I am not able...