View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
aussiegirlone aussiegirlone is offline
external usenet poster
 
Posts: 94
Default Inserting a row below last row of data to Sum total

Yes I need a macro to find the last row of data and then below that, insert a
row with the word "Total!" in the cell AC? and then sum all the Cells
above. The sheet has headers from A1 to AF1 and the column AF1 has the
subtotals. Are you adding column AF data ? Yes All columns have data in them

"Daniel.C" wrote:

Do you need a macro? Are you adding column AF data ?
Daniel

I would like to be able automatically insert a row below the last row of data
that would have the word €śTotal€ť displayed in the column AC and then
calculate the total Sum in column AF. Is this possible