I have an Excel worksheet that tracks gift certificate sales and redemptions. Sometimes the amount redeemed (column Q) is less than the total available (column H). Redemption amount currently turns red to warn staff that there is credit, but they then manually change sheet. How do I write a macro/trigger an event to insert a row below the active cell in column Q to copy the original row data to the new row, change values for (Hnew) to (Horiginal - Moriginal) and then Horiginal to Moriginal. I’m stumped because the row is variable due to the list being in alphabetical order.
Based on your main problem, you can use the following line, to insert a row below the active cell.
'Insert row below active cell
Unfortunately I don't get the purpose of the copy, paste routine you tried to explain. But with the Copy Range command I think you can make your way:
ActiveWorksheet.Range("A1:K" & your_variable_end_of_copy_area).Copy ActiveWorksheet.Range("your_variable_destination_to_insert")
If you paste the code you already have, I could help you in a better way.