On excel, can customer ID generate name address field?

[Guest]

I downloaded an xls template that I am currently using to generate my
invoices. There is one cel where I type the customer ID. And another
combination of cels where I type the customer name and address. Is there
anyway to streamline this operation?

Thanks for any help

 

[Guest]

I don't know. Type faster maybe. lol.
what type of streamlining did you have in mind? Are you making entries from
another data file? Are you doing it manually or by code? You need to be a
little more specific.

 

[Guest]

If you had a file set up with the customer ID, customer name and customer
address assigned to data fields in a similar fashion to your template, that
is, separated to separate fields in the same manner, then it is possible to
use the customer ID to fill the blanks on the template by retrieving them
from the index file.
Is that what you had in mind for streamlining?