Matching the rows and columns to copy and paste from one excel to another excel

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


The problem here I have to match all the rows categories and column name before selecting the value. Any idea how to build this in UI path?

Hi @Rita_Balmukund_Jaisw

Just sharing you can use Filtertable activity just set an output table and thats it.

cheers :smiley:

Happy learning :smiley:

1 Like

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?

1 Like

Hi @Rita_Balmukund_Jaisw

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 :smiley:

Happy learning :smiley:

1 Like

Hi @Rita_Balmukund_Jaisw

If i didn’t get the inquiry you can share your xaml to easilly address the issue.

cheers :smiley:

Happy learning :smiley:

Hi @Rita_Balmukund_Jaisw

I created a sample flow kindly change the path of the excel for your testing.

cheers:D

Happy learning :smiley:Rita.zip (16.2 KB)

1 Like

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?

1 Like

Hi @Rita_Balmukund_Jaisw

Sorry for that.Hmmm i’m kinda confused with your issue.

cheers :smiley:

Happy learning :smiley:

1 Like

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