Excel Copy & Paste

[amrit.karwal]

Hi

I’m using the copy sheet range to copy Sheet1 from File1 and paste into GPSTING Tab on File2.

I want the data to paste over the existing data in the GPSTING tab, however I’m getting an error or it creates a GPSTING2 tab

Can anyone tell me what I’m doing wrong?

Thanks

Amrit

[Pratik_Wavhal]

Hi @amrit.karwal

Can you provide some Input File and Screenshot and the expected output for the same ??

Happy Automation

Best Regards
Er Pratik Wavhal

[balupad14 (Balamurugan)]

Hi @amrit.karwal,

Check this

How to copy one excel row to paste in another excel update row

Hi @Raja.G, You can use the Copy ToClipboard and Paste Clipboard activity that i have attached it here. [image] Regards Balamurugan.S

Video :

Uipath excel copy paste data | Uipath clipboard to datatable

Regards
Balamurugan.S

[amrit.karwal]

@Pratik_Wavhal - thank you for your reply. Unfortunately the files have sensitive data and therefore I am unable to share it. Screenshots below:

I want the data to paste into the existing GPSTING tab as per the below:

[amrit.karwal]

@balupad14 - Thank you, however as explained above I am trying to paste into an existing tab and write over the data, this function does not allow me to do this as I get an error to say: That name is already taken. Try a different one.