At the point of insertion, pause and ask for my "ok" or allow me to choose a different insertion point.
Insertion point to be above third row from the bottom, and make it clear what I can change in the code to make that say the 4th or whatever.
Please keep it very simple (that means no abstract thought or variables if at all possible) as I will be copying it into VBA as desired for use and otherwise keeping it outside Excel and i want to be able to understand it.
Maybe I will surrender to VBA for this, we will see
Here is the current file,GVXkeeping40EE.xlsx
The table is in the DATA sheet.
What you are doing is taking existing transactions and copying them to be re-used for new but similar transactions. This is more of a pain in a structured table than one that is not structured.
Probably apparent I am not right now sure if I want to append or to insert. Which ever is easier to code is fine.