Avatar of Wibble_
Wibble_
 asked on

VBA add row to sheet

I have a sheet with sum totals and other information at the bottom.

there are currently 20 rows for data, with the totals on row 21

I would like to automatically add another row (21) to the bottom (beneath 20) when data is entered in the bottom row (20), and then again if data is added to the new row 21, making the sheet auto expanding. The new row needs to copy all formulas, formatting and conditions from the row above.

I'm guessing that this is a well solved problem, but I've no idea how to do it. Can it be done whilst expanding the range that total cells at the bottom sum to include the new values in the new rows?
Microsoft ExcelMicrosoft ApplicationsVisual Basic Classic

Avatar of undefined
Last Comment
Wibble_

8/22/2022 - Mon
dlmille

It might be very useful if you can provide a sanitized version of your workbook/worksheet to test the VBA against.

Cheers,

Dave
ASKER CERTIFIED SOLUTION
Saqib Husain

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Wibble_

ASKER
ty :-)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck