Address in Excel invoices

[Not Just Talking]

I have been doing my invoicing through Word and want to change to Excel but
cannot find how to automatically enter addresses of my clients. Can anyone
help please?

 

[Toppers]

What do you mean by AUTOMATICALLY enter addresses .... as in the WORD "Mail
Merge" type function?

 

[Gord Dibben]

Probably by using a lookup and VLOOKUP formulas which return the addresses based
upon an ID number or similar.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP