Automating deleting rows
 

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.

Automating deleting rows
 

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

"Alice" wrote:

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.

Automating deleting rows
 

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.


"FSt1" wrote:

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

"Alice" wrote:

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.