macro to reset spreadsheet

Question

I am preparing a business invoice spreadsheet  that will be used monthly to track consultants hours and expenses.  I can develop the one month spreadsheet but want to find a macro that will reset the spreadsheet.  I have contract amount column, prior month column and current month column and total billed column.

Any help would be appreciated!

Answer 1

Have you tried to create a macro by recording the steps?

I suggest,

• put the record macro ON
• (without any error) follow the steps which you would do to reset the spreadsheet
• when every step is completed, STOP recording
• Create a button (

         Click on    DEVELOPER >> 

                              INSERT  >>

                                  select BUTTON under FORMS CONTROL  >>

                                        Create a button at an appropriate location on your spreadsheet by clicking and dragging

                                                Give an appropriate label to the button

                                                       Assign the macro to this button.

Test the macro

Use the macro regularly (if successful)

Hope this is Helpful.