Copy and Paste data as it is from one excel to another


I have done automation to copy and paste data from one excel to another.

Well it's pasting but instead copying the same it's pasting differently.

Please suggest me how to proceed. Attached screens for reference.

The destination data highlighted is not pasting as it is. And also don't want to paste extra 0:00 data as well.

The variable in the automation is "String" for info.


Keep up to date on this post and subscribe to comments

April 24, 2019 - 5:14am

Use export data method and it will give you the data table then you can modify as you want then import the data into new excel.