copying information from different sheet in same work book

[griff888]

I have a list of names on a worksheet called "customer information" The customer names are entered in column A and are listed by entry not alphabetically. I want to be able to take a name from that list and put it onto a worksheet called "invoice details". . I would like to open a drop down box in "invoice details" to select the name and then with a tick box transfer that name to a selected line on the invoice within the "invoice details" worksheet. Hope this makes sense and one of you can help.

 

[robertgama]

First you create a named range of your values. Select the list and in the cell reference box, type a name.

The go to where you want to pick the values and add a data validation list. Data->Data Validation. Select list, press F3 and choose the name range you just created.

Cheers.

Rob.

 

[griff888]

Thanks Rob hopefully this completes my work on getting this invoice sheet user friendly.
Howard

 

[robertgama]

Here are some more details:

 

[robertgama]

If you want your list to be expandable, you can add this neat trick.

Go to the name manager on the formulas tab. Edit the new named range you created and add a formula like this: