Write to new sheet preserving the format and formulas


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!

Hi @nidhi.kowalli

Please refer to the thread below!


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