Record the Steps
8.
Try it: Record the Macro
Select Row
21 (the one with the Sum).
Go to Home->Cells->Insert Sheet Row.
Use the
Format Painter:
Format Same As Above.
Select
Cell A22.
AutoFill
to A23: Fill Weekdays.
Select
Cells B22:E22.
AutoFill
the values to B23:E23
Go to Developer ->Code.
Click on
Stop Recording.
Keep
going, please...