Excel 2007 : Macro to record all sales over the week.

**dazzbilan** · 04-21-2012, 05:48 PM

Could someone please help me either create a formula or a macro for the spreadsheet, to be able to record all sales over the week for each invoice created and save the invoice on the weekly worksheet even once it has been cleared. Also on the ''invoice'' worksheet you will see invoice number does anyone know how to increase that number by 1 everytime the invoice is cleared.

I have made a dummy spreadsheet to try and understand the concept behind how to create how to create this sort on macro.

Any problems understanding how to use the spreadsheets please just reply back to this post.

Please help me ASAP..

Kind Regards

**davesexcel** · 04-22-2012, 01:30 PM

The cells colored green are named cells and you will see the some of them are used in the macros.
The cells in yellow have edited formulas, you may want to edit the cells so you don't get errors.
Data validation is used for Customer Number.
The main menu sheet images no longer have macros assign to them,instead hyperlinks are added to them
To get you the assigned sheets.

You will have to create a folder in the c:\ called Customer Invoices

The code will copy the invoice sheet and pastespecial it into a new workbook saving it as the Invoice number and customer name. You can change that anyway you want.

It will then save the invoice sheet as pdf and save it as the inv # and Customer Name.
Then it calls the maro to send the info to the other sheet and after that call the macro to print the sheet and reset the sheet and add 1 to the invoice number.

Click the little guy with the Wrench to get it going.

**dazzbilan** · 04-22-2012, 06:20 PM

Thankyou so much. One last thing, would there be any chance in creating a monthly and yearly worksheek, where excel automatically sums up the total for each month and week?

Kind Regards