I have an excel sheet named “Recipes” that has formulas and data references that I want to fill out and click a “Save & New” button that duplicates the sheet with the command buttons included to a “Recipe 1”, “Recipe 2”, etc. sheet. A bonus feature would be to clear the original recipe sheet as though it’s an entry form.
I know how to copy and paste a VBA code to a command button but don’t know how to write code myself.
