How to copy the data from one to another with formauls

Help Activities
, ,
1

i want to copy the of the filtered data with formulas to another sheet in the same excel but when iam pasting the data in another sheet formulas are missing?
how can i do this?

2

@T_Y_Raju

Use copy paste range activity in your workflow

3

my data is in datatable how can i pass the values here

4

write range activity is not working

5

Hi @T_Y_Raju

You can use the copy paste range activity

Hope this helps :slight_smile:

6

@T_Y_Raju

Use Excel activities only because you have formulas in your columns.In datatable you not get the formulas.So simply use excel activities use Copy Paste range activity.

Hope this helps you

7

Hi @T_Y_Raju

The Copy\Paste Range activity will not works for this scenario. Instead of this better to use the Vb macros to copy the filtered data and paste it in other sheet then the formulas will not vanish.

If you want to use the Vb macros code then let me know I’ll provide you code.

Hope it helps!!