lists

[tuggers]

Is it possible to create a drop down list with the data of more than one column?
For instance if i have one column that contains player names and one that contains player price can i combine the two in a drop down list or do i have to put all the info in one column.

 

[rs2k]

You could concat the two lists and then create the validation list.

Colin.

 

[tuggers]

please excuse my stupidity but what do you mean exactly?

 

[rs2k]

Assuming Col A is names and Col B is Price and the columns have titles. in Col C paste this formula;
=A2&" "&B2
Copy the formula down to the end of the list. Highlight the list in Col C and then Insert|Name|Define and give your list a name, say 'Players'
Then,choose a cell (say D1) and Data|Validation and choose 'list' from the 'Allow' drop list. In the Source box type, =Players

HTH
Colin.

 

[tuggers]

thank you, youve made me a happy man

 

[tuggers]

one other thing,

how do i get the information chosen from the drop down list to be posted to another page?

 

[rs2k]

If you want to put the data in a specific cell, paste the code below into that specific cell.
=Sheet1!D1

Colin.

 

[tuggers]

I understand the above will post the information to another sheet, but when the original data is changed, so will the new sheets.
I require that once all the required data has been selected the information can then be recorded on another sheet and no longer be altered by changes made to the original, maybe by pressing a confirmation button? to confirm all selections have been made

 

[tuggers]

not sure if the above makes sense, if it does could somebody please help?

 

[rs2k]

tuggers,
Check your private messages, if you want a sample file.

Colin.