Clarebabes

I have just started work at a new company and they do not have any formal invoice software. Therefore, they use Excel to do the invoices and then just print them off. I was wondering if it was possible to use LOOKUP to have a separate list of products and then just put the product code in and it comes up with the description and unit cost.

So, if I make a three column table with Code, Description and Unit Price as headers, how do I get the information into the actual invoice template?

I hope this make sense! I have no idea where to start. I can do simple formulae, but this has me stumped!

Cheers in advance!
Clare

super_si

if your staring from scratch, why not just use access.

create some nice VB forms, your away,

use queries to rip data you need

Si

Scooby-Doo

YHM

Clarebabes

Scooby-Doo, thank you!