Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Address from one worksheet to another
Hi,
I have a worksheet which contains customer names and their addresses, so that customer name is in column A, address line 1 is in column B, address line 2 is in column C and so on. I have a separate worksheet which has the customer name in a drop down list in Cell A1. What I want to happen is when I choose a customer name in cell a1, it picks out the relevant line from Column B (address line 1) and puts it in cell A2, and address line 2 in cell A3 and so on. This is for invoicing. Is this possible and, if so, what formula would I need ? Any help gratefully received, Duncan |
#2
|
|||
|
|||
Hi Duncan
Assume sheet 1 is the list of name/addresses. Create a Dynamic name list on the sheet1 with names see : http://www.contextures.com/xlNames01.html#Dynamic Then on sheet2 use data validation using list in your Name Column to get the drop down list. Then use vlookup to get the Address1 and Address2 in the other coloumns. HTH "Duncan" wrote: Hi, I have a worksheet which contains customer names and their addresses, so that customer name is in column A, address line 1 is in column B, address line 2 is in column C and so on. I have a separate worksheet which has the customer name in a drop down list in Cell A1. What I want to happen is when I choose a customer name in cell a1, it picks out the relevant line from Column B (address line 1) and puts it in cell A2, and address line 2 in cell A3 and so on. This is for invoicing. Is this possible and, if so, what formula would I need ? Any help gratefully received, Duncan |
#3
|
|||
|
|||
Al,
Thanks for your reply. With your help I've done the first part (up to getting the drop down list). I'm stuck on the vlookup bit though. Thanks, Duncan "Al" wrote in message ... Hi Duncan Assume sheet 1 is the list of name/addresses. Create a Dynamic name list on the sheet1 with names see : http://www.contextures.com/xlNames01.html#Dynamic Then on sheet2 use data validation using list in your Name Column to get the drop down list. Then use vlookup to get the Address1 and Address2 in the other coloumns. HTH "Duncan" wrote: Hi, I have a worksheet which contains customer names and their addresses, so that customer name is in column A, address line 1 is in column B, address line 2 is in column C and so on. I have a separate worksheet which has the customer name in a drop down list in Cell A1. What I want to happen is when I choose a customer name in cell a1, it picks out the relevant line from Column B (address line 1) and puts it in cell A2, and address line 2 in cell A3 and so on. This is for invoicing. Is this possible and, if so, what formula would I need ? Any help gratefully received, Duncan |
#4
|
|||
|
|||
Sheet1:
A1 = Name B1=Address1 C1=Address2 Sheet2 A1=Dropdown List B1=vlookup(a1,range,2,1) C1=vlookup(a1,range,3,1) where range is the table array where your nae/address information is located. HTH "Duncan Sibbald" <duncansibbald"no spam" wrote: Al, Thanks for your reply. With your help I've done the first part (up to getting the drop down list). I'm stuck on the vlookup bit though. Thanks, Duncan "Al" wrote in message ... Hi Duncan Assume sheet 1 is the list of name/addresses. Create a Dynamic name list on the sheet1 with names see : http://www.contextures.com/xlNames01.html#Dynamic Then on sheet2 use data validation using list in your Name Column to get the drop down list. Then use vlookup to get the Address1 and Address2 in the other coloumns. HTH "Duncan" wrote: Hi, I have a worksheet which contains customer names and their addresses, so that customer name is in column A, address line 1 is in column B, address line 2 is in column C and so on. I have a separate worksheet which has the customer name in a drop down list in Cell A1. What I want to happen is when I choose a customer name in cell a1, it picks out the relevant line from Column B (address line 1) and puts it in cell A2, and address line 2 in cell A3 and so on. This is for invoicing. Is this possible and, if so, what formula would I need ? Any help gratefully received, Duncan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export address list data in an Excel worksheet for importing into. | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Copy Worksheet Tab Name into a cell address | Excel Discussion (Misc queries) | |||
Can I import my excel worksheet to my address book | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |