Creating a reset button for a Invoice

Hi,

I would like to create a "RESET" button which would reverse all the cells to back to the original state.

As you can see in the attached file that in the "Original state", all the quantity starts with the amount of 1.
All the values in the "PRICE" starts with the value 0, and the "ITEM" is always empty.

If a customer comes I insert the "Item name" and the "price", and also change the quantity if needed.
But after I am finished I would like to be able to have the sheet reversed back the "Original state" with a push of a "Command button".

I guess I would need a macro to accomplish this, but I have never used one before.
Could somebody help me with this please?

RESET BUTTON.xlsx

Hello
See the attached workbook to see if it does what you require. You'll have to allow macros when you open the file. I've added 3 named ranges Item; Price; Quantity to reference in the macro.

Hope this helps

hi,
maybe this

Please Login or Register  to view this content.

ps
sorry DBY, not refresh before sending...

you're welcome!

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.


How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save