Is there a way to enter a formula so that excel automatically calculates successive invoice numbers?
K KSR Sep 30, 2004 #1 Is there a way to enter a formula so that excel automatically calculates successive invoice numbers?
F Frank Kabel Sep 30, 2004 #2 Hi could you explain with some more detail what you're exactly trying to achieve?
G Gord Dibben Oct 1, 2004 #3 KSR Do you want to increment Invoice Numbers? Be careful what you ask for....you may get it<g> Would you like the number to increase each time the workbook is opened even if no changes are made? Would you like the number to change when the workbook is closed, saved or printed? Read this google search thread to find out options and see code. http://snipurl.com/8co5 and this one http://snipurl.com/8cob Gord Dibben Excel MVP
KSR Do you want to increment Invoice Numbers? Be careful what you ask for....you may get it<g> Would you like the number to increase each time the workbook is opened even if no changes are made? Would you like the number to change when the workbook is closed, saved or printed? Read this google search thread to find out options and see code. http://snipurl.com/8co5 and this one http://snipurl.com/8cob Gord Dibben Excel MVP
