Juniad Active Member Jan 4, 2020 #1 Please see the attached. Need help to change the invoice number based on customer name changing. without VBA, Because i have to use in google sheet. Attachments invoice-template.xlsx 16.7 KB · Views: 11
Please see the attached. Need help to change the invoice number based on customer name changing. without VBA, Because i have to use in google sheet.
N NARAYANK991 Excel Ninja Jan 4, 2020 #2 Hi , Doing this without VBA is risky because it is entirely dependent on the recalculation method being manual. Excel has no foolproof formulaic method for detecting transitions , which is what you want here. VBA has the Worksheet_Change event which recognizes when a worksheet cell has been changed. If Google Sheets has any such equivalent formula which can detect transitions , you should use that rather than do it using Excel formulas. Narayan
Hi , Doing this without VBA is risky because it is entirely dependent on the recalculation method being manual. Excel has no foolproof formulaic method for detecting transitions , which is what you want here. VBA has the Worksheet_Change event which recognizes when a worksheet cell has been changed. If Google Sheets has any such equivalent formula which can detect transitions , you should use that rather than do it using Excel formulas. Narayan
