Hi,
I am building quicker way to invoice my clients and I was hoping to do something like this.
I want to be able to enter an account number for the client that I am billing and have all of their information from a different sheet auto fill in different cells.
for example:
|____________A________________ |___________B_________________________|
1| ______Account Number__________ | 02354 (I would enter this manually)______|
2|______________________________ |_____________________________________|
3|_______Address_________________| 123 Maple Street (auto filled from sheet 2) |
4|_______Amount Due:_____________| $500 (auto filled from sheet 2)___________|
5|_______Due By:_________________| 01/01/2012 ___________________________|
6|_______________________________|_____________________________________|
I hope this is clear. Let me know if you have any suggestions.
Thanks,
John James III
Bookmarks