![]() ![]() the invoice number that generated should never be used again even if its not in the masterfile any more and a row's invoice number should never be changed/recalculated when the code runs again. I want the code to work something like this:įind empty cell in column k_generate invoice # for columns cells K based on last previous cell invoice # for all column k cells that have content in row to the left and stop generating when rows are empty. In the masterfile, columns A thru J are auto-populated with the finalized order and I want column K to be where the invoice number lives. The "CD-" is fixed and won't change, but the "1000" needs to be unique for every row line I need a code to generate a number that looks like this: CD-1000 I current have a 'masterfile' that records all finalized orders for each facility. this number is going to be an invoice number. ![]() I need a macro/vba code that auto generates when there is cell content in a row of a worksheet. ![]() I am a pharmacy student in serious need of help for my internship.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |