Link to home
Start Free TrialLog in
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?
Avatar of dlmille
dlmille
Flag of United States of America image

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
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Wibble_
Wibble_

ASKER

ty :-)