Hello Friends,
I am new to UI path. I am working on building automation, where I have an excel with table containing row, column names and some financial data as shown below:
I want to copy these value into an another excel having similar table structure
Just sharing you can use Filtertable activity just set an output table and thats it.
cheers 
Happy learning
So here I am using read range activity to read data table available in sheet. Now with this data table how should I able to paste the value to another excel with filtertable activity?
because filter table activity does not provide rows names and use only column names?
I think i didn’t get right.
Please use the filter table and get the column that you want and create an output datatable and write it to excel.!
cheers
Happy learning
If i didn’t get the inquiry you can share your xaml to easilly address the issue.
cheers
Happy learning
I created a sample flow kindly change the path of the excel for your testing.
cheers:D
Happy learning Rita.zip (16.2 KB)
Hi Patty,
Thanks for the workflow.
The problem with this is that it is pasting full data from excel 1 to excel 2. However, excel 2 has fixed table with row categories name and months in the column. I have to grab only those values from Excel 1 for rows and columns matches with Excel 1. So it is kinda of an lookup from one excel to another but the no. of criteria for lookup is multiple.
I was working with single lookup data table but currently it is taking single value in lookup.
Is there any workaround for this?
Sorry for that.Hmmm i’m kinda confused with your issue.
cheers
Happy learning
Hi,
What if the order or the structure of the excel sheet is different from the data table, will it work in that case too.if not then how
hey rita, have you done with this problem? can you give me your email so that i can contact you because i have this kind of problem too
