Copy whole sheet but remove formula only, keep the value and format(box etc)

Help Studio
1

Hi All,

Problem as header, any recommendation?

2

Hi @Syah_RPA

First use a copy sheet to copy the sheet exactly and then use copy/paste activity to copy paste only the vlaues wherever you have formulae

Cheers

3

can u share the workflow? For me getting error because it copy the formula also

4

Hi @Syah_RPA

Please change the property like this in copy/paste and then give the ranges

image

cheers