Add row to table based on second to last row

[wbstadeli]

Hi friends,

I want to add a new row to my table "Time_log" based on if there is any content in the second to last row of the table (the very last row is my "totals" row). I want this to trigger whenever someone adds content to the second to last row, so that it make a new row available for more entries. So probably trigger with worksheet change event? Unless there is a better option?

Thanks!

 

[Ahsanalikhan9]

So, but you need to clear your question. It's confusing.

 

[sandy666]

try:

remove your Total row

select whole range and use Ctrl+T (it will change your range to Excel Table)
click enywhere inside the table and from the right click menu select : Table - Totals Row
under appropriate column in Totals Row set: SUM, Average or whatever you want

add new row:

1. select bottom right cell with data (but not in Totals Row)
2. hit TAB key
3. enter new data
4. if you want more rows repeat these steps

 

[wbstadeli]

Sorry, i guess i wasn't clear on what i wanted. I need a code to run with a worksheet change event, that looks at Column #1 of my table "Time_log". If i add data to column 1 in my table, run code to check if second to last row (in table "Time_log") has any values (content), then add row to table, if not, then do nothing. I still need my "totals" row which is the very last run in table.