Hi All, I am trying to do a copy paste range where the source range has formulas. I need to only copy the values. But when Bot is pasting the value in the destination range, any change in source range get auto reflected into destination range.
Referring to the image. Columns having green colour has formulas. Blue columns are copy of green columns. Now when data updates in Q1’25, then same values are feclecting in Q1’24.
Can you check by setting what to copy as values in modern copy page range activity.
Do mark it as a solution if it helps you 
Happy automation
Please don’t post response from ChatGpt
It should work, or you can read that sheet and store in data table then write that in another sheet. this will only past the values.
Happy Automation
Already used Read range and write datatable to excel activity. The moment it finds updated values in green columns, same values gets updated in blue columns.
You can see in the image if green columns are having null, then blue will have expected value. in case anything gets updated in green then it will change the values in blue as well
if possible can you share the sample input excel which you are using
Unfortunately I can’t!
If the format is not important, can you try using
read range and read the excel to dt
and write it back to destination
Try this!
Is the source and destination mentioned is correct or needs to be swapped?
Are you copying the columns from right to left or left to right??
