Copy data from one excel to another based on row and column name

Help Studio
, ,
1

Hi ,

I have a two excel File1 and File 2, I have to get the data based on row and column and paste the data to File 2 under the specific column name:

eg: File 1 : I have to get the Column 3 data of “Flowers” ,“Fruits”, “Colors” and paste to excel File 2.
any simple activity can achieve this step ?

File 1:
image

File 2:

image

2

Hi @monishanair2010

Please follow this link. Thats the exact thing that you need

Cheers

3

Thank you Anil, I many not need all the column values from File 1, only selected cell values.

also the File 2 I need only the column 3 values of File 1 , headers will be already there and we just need to paste those values based on header names.

Still you think this way is possible ?

4

Hi @monishanair2010

Yes it is…if you aleast know the column then just use it only on that column and leave out the other or dont run the loop… just follow the video and make modifications as per single column

Cheers