How to copy and paste excel to excel with format painter

Help Activities
, ,
1

Hi Team,

I have 2 excel i want to copy to paste one excel to another with formatting

Paste excel(second excel) having with formatting center alignment format cell some column value is custom , general, date like that is there , while i going to paste skip header and last row.

Last row is sum formula is there.

Please help me anyone for this.

Input excels:
image

image

Expected output:
image

Regards,
Raja G

2

Hello @Raja.G,

Is the formatting always a fixed one ? If so You can use Format activity available in the Modern excel activity.
For calculating the sum in Column B , you can fetch the last row and Update the formula in Last row + 1 , Like Sum(B:B)

1 Like