Autosave with the filname = a value of a pre-defined cell & to a pre-defined location?

[alfgrey]

Hi, I have an invoice template that auto generates an invoice number in (sheet/cell) Invoice!$M$7 based on criteria in another workbook. Is there a macro that enables me to click 'Save' and then the workbook saves as the file name=Invoice!$M$7 and saves to a pre-defined folder C:\Users\OFFICE\Dropbox\AGL\Invoices\2013-14

If there is such a macro, my concern is if I wanted to amend the actual template and NOT produce an invoice how will I make the workbook saves as the template file name and not the auto generated file name?

Im a complete novice at macros so my apologies if this is a redundant question, any assistance greatly appreciated.

[Fotis1991]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.