i’m new using UiPath and am developing a bot for excel activities.
I have 2 excel files.One file (database.xls) consist of a database containing all data collected during the year (lot numbers,…).
The other (batch nr.) contains a list of lot numbers for which i have to search and copy some specific data i need from the database, in order to perform a data analysis.
I already managed to perform the search part in the database using filter activity. But I could not manage to copy the data i need yet.
Can you please help ? Do you have suggestions how to perform that search and copy function ? perhaps using another method.
I’m not an expert in programmation at all.
You can find attached my Uipath file and both excels files.
Thank you in advance