How to copy some data from one excel to other

Help
, , ,
1

Hi everyone,I have an excel sheet in which there are some columns that I want to copy in the other excel sheet.The layout of both the sheets is different but I want to move the data.I have tried Read and Write activity but cant get the desired result.I even tried for each loop and again cant get the result in the way I would prefer it to be.Please help me on this as this is something work related and I have to report about it sooner.

2

you are selecting based on the columns?

1 Like
4

just use filter data table activity and specify the column names you want . then write that data table to excel.

1 Like
5

ok,Thanks
Will try and let you know

1 Like
6

Yeah sure.:slight_smile:

1 Like
7

Drawing Register.xlsx (289.6 KB) P306479_Tender_Drawing_list_CORRIGENDUM_3.xls (43 KB) Main.xaml (11.0 KB)

CHECK this is it what you want?
You can make changes as per your need

2 Likes
8

Thank you so much.It worked
Happy Coding

1 Like
9

Welcome !!
Happy Automation !

1 Like
10

Hi @ImPratham45
I need your help again,Can you please help me split the values in output excel to single single cell?

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.