I AM TRYING TO ACCOMPLISH THIS EITHER WITH A MACRO, OR A FORMULA. I HAVE 2 SEPERATE WORKBOOKS. I WANT THE INVOICE NUMER ON SHEET A TO LOOK ON SHEET B IN COLUMN A FOR THE LAST NUMBER IN THE COLUMN AND ADD ONE TO IT. CAN ANYONE HELP ME WITH THIS
Sorry about the caps. I draw home plans, and forget to turn it off. I might have worded that worng. I have 2 seperate workbooks. I want workbook a to look on workbook b, and find the last active cell and add one to the numer and place it back onto workbook a. Thanks for the formula, I can use that in another place.