pick from list

[canablitz]

on my project i have an invoice, and there is a place for customer address, and oon another sheet i have all the members details,
how can i transfer the members name, address etc onto the invoice by picking from a list?

Please help me, as i am nearly on the verge of suicide

[gareth]

I just thought I'll reply we have one less poster on Mr.excel.

I am able to help you with a code I have written.Please give me a chance to search my Laptop.

[Jack in the UK]

hi no need to get to worked up, sure i can guide you a little... VBA not needed.

Lokk set a client num,ber in the customer records say Col A if A used inset to left making A now B and A all new / blank.

ID the rows of data.

Now inv sheet.

put customer number above address and vlookup the next few rows of address and then, the data will transfer by linking the user number o the inv sheet to the inv no in the data sheet.

try:

=VLOOKUP(A3,'Data sheet'!A1:D10,3,0)

This wil be in the Invoice sheet

See the 3 this needs changing to 3 4 5 6 whatever..