MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I need ideas on a macro.....


Posted by Mark A. Lowe on September 18, 2001 4:51 AM

I'm putting together a workbook that will allow me to write invoices. I would like to keep track of the invoice amounts, so i need to write a macro that would, after printing, add the amount of the invoice to another sheet. What has me hung up is how do you write the macro so it adds the invoice amount to the next available cell??

Thanks,
Mark


Posted by lenze on September 18, 2001 7:12 AM

Mark: Depending on how complex your invoice is, the Template Wizard with Data tracking could do the the trick. You would make your invoice a template and each time it is saved, you can update a database with a new record. See this link a Microsoft for info:
http://support.microsoft.com/support/kb/articles/Q214/2/46.ASP?LN=EN-US&SD=gn&FR=0&qry=template%20wizard&rnk=4&src=DHCS_MSPSS_gn_SRCH&SPR=XLW2K