hello, I am pretty decent with VBA enough to get myself through. but have not much experience with tables.
what I would like is a table like in my example that leaves all the rows with data, weather the table is mostly blank hidden rows or it adds rows as needed dynamically. I would like 2 blank rows at the top to add data. then dynamically sum the rows at the bottom as I add data. if possible at the top of the table just have the three column headers, (expenses, income and YTD) just appear in cells with the totals beside them for reference at the top of the sheet. I have attached my workbook
Bookmarks