I have followed the contectures website to no avail. I am trying to creat a fantasy football draft wroksheet and I have 7 drop down options: Top200, QB, RB,WR,TE,K, DEF With each of these drop downs is also a column with Taken. If they are taken then the status changes to yes. SO I want to be able to edit the data in the drp down list to validate the the player is not taken and if they are

On Apr 25, 12:06 pm, Neil M <neilmonk...@hotmail.com> wrote: Is there a work around to creating lists on wroksheets from other worksheets. I would like to have one worksheet with all my reference lists and data on it. Yes create a named range. Go to insert name define... Give a range or individual cell a name. then you can call the name from the data validation by =Name. Then when

The data from payroll is imported from a payroll system - this doesnt take too long The data from the training system is imported via ODBC from a database view/query this is very fast and doesnt take long.. "Joel" wrote: You should look at some of the VBA solutions under Programming. Sometimes it is easier/better to complete tasks like this using worksheet formulas and other times

On Fri, 28 Dec 2007 04:52:34 -0800 (PST), creusa <suewhiteman2706@yahoo.co.uk> wrote: On 28 Dec, 11:35, Maria <mariathom...@btopenworld.com> wrote: On Fri, 28 Dec 2007 05:15:30 +0100, abelard <abela...@abelard.org> wrote: 10 years of 'new' labour http://www.telegraph.co.uk/opinion/main.jhtml;jsessionid=ZKAYK3ZF0FWR... "The attrition rate has risen dramatically