I have a small problem that I can’t seem to resolve. I have two tables. One is a master record and the other monthly transactions. The monthly table starts with an ‘initial’ balance (which is the basis for a running balance) that is also the closing balance of the previous month. At the end of each month I want to copy the all rows of the monthly transactions to the master record… except for the very first row.
When I copy the first row, it is, in essence a copy of the very last row of the previous month… This screws up running balances and totals.

My question: How would you append all rows of one table to the bottom of another minus the, of course, the headerrow and the 1st row of data.

AppendAllButFirstExp..xlsm

Thanks in Advance
Scott