Copy the data from a specific cell in an excel1 and paste the copied data in different excel2 in a specific row

Hi

how to copy the data from a specific cell in an excel1 (B10)and paste the copied data in different excel2 in a specific row

test

1 Like

@venkateshtangudu

use Read Cell activity to read data from specific cell and then use Write Cell activity to write into specifi cell.

hi

here sheets are different

Hi
— hope these steps could help you resolve this
— use excel application scope activity and pass the file path of excel1 as input
— use a Read Cell activity inside this scope and mention the cell as “B10” and mention the sheetname— get the output with a variable of type string named out_text
— now use another excel application scope activity next to this scope and pass the file path of excel2 as input
— inside this use a Write Cell activity and mention the sheetname where to enter this data and the cell between quotes “” where to enter

Simple isn’t it
Kindly try this and let know for any queries or w
Cheers @venkateshtangudu

That doesn’t matter buddy
If they are of different excel then we can use two different excel application scope
Or
If they are from same excel but different sheet we can mention the sheetname in the write cell activity inside the same excel application scope where read cell was used
Cheers @venkateshtangudu

@venkateshtangudu

Ok. You can specify Sheet Name for those activities.

Both are in same excel or different ?

hi,

different sheet1(Ack1) and sheet2(Billing)

1 Like

Hi @venkateshtangudu

You can do dt.Select("[Sum of Belop Nok]<>’’"). Copytodatatable ()

Then you can use write range

Thanks
Ashwin.S

No worries while reading with read cell use the sheetname as “Ack1” and while write cell mention the sheetname as “Billing”

But we need to be careful with the cell where we are going to type
Cheers @venkateshtangudu