I need help with a vba code or formula that will help me do the following (I know that I should at least show some code of what I have so far but I am new to excel and have no idea where to even begin):
I have two (2) workbooks, wb1 and wb2.
wb1 has two sheets, sheet1 and sheet2. Sheet1 holds invoice numbers. Sheet2 is the invoice. I need to populate the next invoice number from Sheet1 onto Sheet2 without duplicating any invoice numbers, for example, the last invoice number is 19567 so the next populated number should be 19568 and so on. Then, after the invoice is filled out I need it to be copied over to wb2 and saved under that invoice number. I hope this makes sense. Any help would really be appreciated. Thanks in advance.
I have two (2) workbooks, wb1 and wb2.
wb1 has two sheets, sheet1 and sheet2. Sheet1 holds invoice numbers. Sheet2 is the invoice. I need to populate the next invoice number from Sheet1 onto Sheet2 without duplicating any invoice numbers, for example, the last invoice number is 19567 so the next populated number should be 19568 and so on. Then, after the invoice is filled out I need it to be copied over to wb2 and saved under that invoice number. I hope this makes sense. Any help would really be appreciated. Thanks in advance.
