Copy paste rows to different sheets in same excel

Help Studio
, ,
1

Hi Everyone

I have 4 sheets

  1. 2021 - SSC
    2.SSC - 2020 and earlier
    3.2021 - SMC
    4.SMC - 2020 and earlier

This flow is scheduled once in an year
My need is :
1.based on some conditions copy rows from one sheet to another

Im using an excel scope , iterating through each sheet and stores rows in different datatables

and using write range writing it into different sheets
eg: SMC - (datatime.now.year-1) and earlier so it is renamed but the problem i need to maintain the format of the excel which get disturbed while using write range

Thank you in advance

1 Like
2

Hey @kavya.s16

You mean to say, copy pase logic between sheets is working fine?

But the format of the sheet is not getting as expected.

Thanks
#nK

3

Hey @kavya.s16 !! Can you share a sample Excel file with dummy data?

Thank you!

4

Exactly

5

Ok @kavya.s16! First copy your previous sheet that contains the formatting you already want.

image
image1920×656 63.2 KB

Then clear all data from your new copied sheet, so it will be empty and with the same formatting as the original.

image
image1920×986 74.9 KB

Finally, write your data on this sheet.

Hope it helps!!