Automating deleting rows

  • Thread starter Thread starter Alice
  • Start date Start date
A

Alice

Hello.

I am looking for a solution to remove extra, or add more lines as required
on a spreadsheet.

Information is gathered from one or two spreadsheets which varies from week
to week, and tabulating the information onto another spreadsheet.

Is there a way of adding/removing lines as required for a section of the
spreadsheet, and still have the SUM feature adjust and work as well.

I hope this makes sense.

Thank you for your assistance.
 
hi
automation...
you could attach these macros to custom icons. with each click on the icon,
a row would be added or deleted.
Sub addrow()
ActiveCell.EntireRow.Insert shift:=xlDown
End Sub
Sub delrow()
ActiveCell.EntireRow.Delete shift:=xlUp
End Sub

regards
FSt1
 
Hello and thank you for your response.

I wasn't sure if my question was clear... what I am looking for, is that the
adding/removing rows would be automatic based on the information being pulled
from another spreadsheet.

I hope this helps explain.

Item 1 Total Amount: $xxxxx
Date Activity Amount
Date Activity Amount

Item 2 Total Amount: $xxxx
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount

The next time Item 1 could have 14 items, and maybe Item 1 would have 3
items. The "Date/Activity/Amount" would be variable each week, and the Total
amount would have to sum up the items.

Thank you again, for your reply. Your suggestion would work to add/remove
lines.
 
Back
Top