![]() ![]() However when i have about 800 rows, as soon as i type anything into column A or B it slows down my excel because it's +1 to allllllllllllllllll the rows below.Īny efficient & effective ways to generate invoice numbers solely based if A or B is filled, i was thinking a macro that would generate the invoice number, and when this is executed, it will rename the cell formula as "last number", the macro continues to loop and pulls "last number" and +1 if A or B is filled, this way im not changing hundreds of rows, itll auto do it, also another benefit is if i EVER GO BACK a few dates and a NEW ROW half way or at the start of my sheet, it would mess up all the invoice #'s below, for example I did last row +1 IF column a or b is NOT blank, and if they are blank to show the last row invoice # without adding 1 It must +1 from the last invoice number generated I want to create a new invoice number for each ROW that has any value in either column A or B I want to generate a "sequential" number in column M ![]() ![]() They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |