software

Hi there,
I have a list of people that I invoice on a fortnightly basis. I would like to create an invoice whereby when I select a name from a drop down list, this selection auto-populates other cells on the invoice such as TAX ID number, Client number and banking details, all of which I have in seperate lists.

EXAMPLE:
I select John Doe from my drop down list and this automatically populates cells with John Doe's TAX no., etc etc.
Any help would be much appreciated
YOu can use VLookup formulas to return the matching data. There's
information he

www.contextures.com/xlFunctions02.html

And a sample here which fills in Customer info on an order form:

www.contextures.com/xlOrderForm01.html#Customer

chrismcon wrote:
gt; Hi there,
gt; I have a list of people that I invoice on a fortnightly basis. I would
gt; like to create an invoice whereby when I select a name from a drop down
gt; list, this selection auto-populates other cells on the invoice such as
gt; TAX ID number, Client number and banking details, all of which I have
gt; in seperate lists.
gt;
gt; EXAMPLE:
gt; I select John Doe from my drop down list and this automatically
gt; populates cells with John Doe's TAX no., etc etc.
gt; Any help would be much appreciated
gt;
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlMany thanks Debra

Originally Posted by Debra DalgleishYOu can use VLookup formulas to return the matching data. There's
information he

www.contextures.com/xlFunctions02.html

And a sample here which fills in Customer info on an order form:

www.contextures.com/xlOrderForm01.html#Customer

chrismcon wrote:Hi there,I have a list of people that I invoice on a fortnightly basis. I wouldlike to create an invoice whereby when I select a name from a drop downlist, this selection auto-populates other cells on the invoice such asTAX ID number, Client number and banking details, all of which I havein seperate lists.
EXAMPLE:I select John Doe from my drop down list and this automaticallypopulates cells with John Doe's TAX no., etc etc.Any help would be much appreciated

--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html