Auto insert blank new cells

[tra1a]

I am fairly fresh to Macros.

4 columns: B23, C23, D23, E23

Headers: type, vendor, amount, date

data cells

Footer: sums total

Need Macro that inserts a new blank row below most recent row whenever data is recorded in the previously blank row.

Make sense? I know this has been answered before. I am not sure I'm at a point where I know enough to adjust another code.

 

[tra1a]

True. The effort-to-outcome is maybe not worthy.

I assume with the others it could just enter cells outside the table to keep everything even. Still, hidden rows are out.

I'll look at some of the links on your signature tomorrow and upload. I'd love to get it working how I have in mind. If it were for my own person use I just manually enter new cells.

Thanks again. At the very least I'm learning a bit.