Deleting data and increasing a number by 1 when I hit the "Delete Button"

Hello All -

I am in need of assistance.

I am trying to develop a macro that will not only delete data from the "Orders" tab, but will increase the number as shown in cell M3 (with a formula combining a few things in cell E3)

What I have for the Deleting of data from the "Orders" tab is -

Please Login or Register  to view this content.

and the program to increase the number by 1 everytime is -

Please Login or Register  to view this content.

I would like to combine the two so that both happen with the same click of the "Delete Data" button.
I know I am close, just can't figure it out.

Any help would be appreciated.
Thanks.
Dave

Your code has macro recorder bloat. I have proposed a streamlined version, also combining as requested.

Also, I strongly recommend to everyone that they use Option Explicit and declare variables. Doing so prevents a lot of bugs and runtime errors.

Please Login or Register  to view this content.

Glad to help! Nothing to apologize for, although because you are a member who's been here longer than me and with 125 posts I was obliged to flag it.

I, and every other expert here, will recommend against using merged cells, and you have found one of the reasons. It is almost always possible to give the same format by using Horizontal > Center Across Selection. There are a small number of times when merged cells are the best solution, but that means that Excel might not be the right tool for the job.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking Add Reputation below their name.

If you solved your own problem, please provide your solution so that somebody seeing this thread in a search for the same problem will see how it was solved.

It is a structured table referenced. It means the data in table Data3 in the column labeled QUANTITY.