Originally Posted by
santiago
What do you need to do with your vendor/voucher thing? Sounds like it may be a candidate for VLOOKUP. For more complex 'spreadsheets' I build an Access database and have Excel query the data. Complicated lookups are written as SQL statements in the Access DB or Excel.
This might be one of those coding-vs.-manual time spent things, but here goes:
It's a simple voucher form that has one field where I type in the vendor number. If it's one of my nine most-used vendors, the next field below automatically fills in with that company's name. It would just be nice to have most of my vendors set up this way rather than just the nine that I can put in the conditional statement. Here's the form:
Voucher.zip
If I have to get too elaborate I'll just keep muddling on the way I have been. Thanks for whatever help you can give.