Write to new sheet preserving the format and formulas

Help Activities
, ,
1

Hello,

I need to read, say “Sheet1”, filter based on particular Column and write it to “Sheet2”.
Preserving the Whole format including Formulas.

How do I do this?

It’s a GIFU excel file.!

Kindly provide solution!

2

Hi @nidhi.kowalli

Please refer to the thread below!

Regards

3

You can try to create a copy of the sheet and then do deletes or updates on the copied sheet