For example, I need to create primary dropdown “Country” and dependent dropdown “City” in the excel file “Target File.xlsx”. But List of Countries and their respective Cities List is in another excel “Source.xlsx”. Please suggest how to proceed
Hello,
You want to do this via UiPath? Sounds more like a normal Excel issue unrelated to RPA?
Yes, I need to do it using UiPath
My requirement is part of the Automation Process
there is no direct activity as such
record or write a macro or vba and use it
cheers
I don’t have much knowledge in writing macro. I tried writing macro but getting error while executing the macro
I think it would make sense to make a template for the Excel file here no?
Then all you need to do is use UiPath to add some formula’s to the cells that are the source for the dropdown, which can be done with the native UiPath activities, the rest can be default in the template, minimizing your coding.
1 Like
what @Jon_Smith mentioned is also a good option try the same
if not I can create a macro and give as well
cheers
1 Like
I tried on the macro one issue i see is to use indirect or to create dependant dropdowns..we have to have the data in same workbook. so if its ok to copy sheet to same workbook then we can move ahead
cheers
@Anil_G
yes, we can have the source data in the same excel for now. Once dependent dropdown is created, we can hide the source data sheet.
please try the macro in this I have written with example…you can adapt to your type
in sheet2 you have dropdowns..sheet1 is the input
copy sheet can be used to copy
Sample.zip (25.2 KB)
cheers