Get last cell value and copy to another workbook??

[JHARO-77]

Hello to all, I am new to this board. I need help with the following. I have 2 workbooks, WB1 and WB2. In WB1 I have two sheets, S1 and S2. S1 has a list of invoices with customer information. In colunm A is the invoice numbers in sequential order from 1001. S2 is the invoice I fill out. How do I get the last invoice number from S1 and add 1 so that the invoice number shows in S2 everytime I save the sheet? Secondly, how do I save the newly created invoice to WB2? Much help would be appreciated.

WB1 - S1
Inv No. Name Address City Zip Code Phone1 Phone2
1001 John S. ... ... ... ... ...
1002 Jane D. ... ... ... ... ...

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=608912

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).