SEARCH AND ADD ONE FORMULA, OR MACRO

[JOSTERBAUER]

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

 

[fairwinds]

Welcome!

Try:

=LOOKUP(9.99999999999999E+307,Sheet1!A:A)+1

(and don't type in caps)

 

[JOSTERBAUER]

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.

 

[fairwinds]

But isn't that what this formula gives?

 

[JOSTERBAUER]

The workbooks are not in the same file. I think I have accomplished this with a macro. I have to refer from the sheet A to a different file, in a different foder.