Children Name Randomly Selecting From Predefined List

Jun 25, 2012

My wife is a teacher and she has asked me if there was a way of randomly selecting a child's name from a pre-defind list and for that child not to be selected again during that session.

Some criteria:

Up to 35 children in the class (selected from a pre-defind list)A child can only by picked on once during the lessonA method needs to be in place for seelcting the child's name (either a button that can be pressed, or another option).

View 2 Replies


Locate Files Of Predefined Extension, In Predefined Location & List In Spreadsheet

Oct 22, 2008

I require a bit of code that locates where the excel file is stored - it then searches that directory folder for all file names. Any file names with an extension *.hm for example are listed in column A, while their relevant 'Dates of last Modification' are listed in Column B.

Every time the spreadsheet opens it should ask the user if he/she requires a re-search of this directory and update of any file names accordingly. NB: if a file name is deleted from the directory, the file name should remain in the spreadsheet.

View 3 Replies View Related

Randomly Selecting A Cell From A Range

Oct 14, 2008

I need a cell to display the (text) content of 1 of 25 cells. example: I have text content in all cells ranging A1:A25. I want cell B1 to display the content of 1 of these at random. is there a function for this or do I need to use a macro?

View 4 Replies View Related

Choose Parent And Return List Of Bottom Level Children?

Apr 16, 2014

I have a large flat hierarchy table. I am looking for a method to select a parent and return a list of my lowest level children. I am somewhat familiar with VBA but I don't know where to begin coding this.

This has been a great learning source over the years, but this is one of the few instances I cannot find my problem so I am now posting. Example below:











If I select 5, I want values 2 & 1 returned.
If I select 50, I want values 20 & 10 returned.
If I select 100, the value 100 should return.
If I select 40, the value 20 should return.

View 6 Replies View Related

VBA - Run Macro From Predefined List Of Times?

Jun 25, 2014

I've seen a lot of traffic around running macro's on a clock at regular intervals. But what if I want to run a Macro (Macro1) at 8:55, 9:55, 11:55, 12:55, 13:55, 16:55 and another Macro (Macro2) at the top of each of those hours? The string of times is not consecutive, so I have built a table to define the release times. At each of these times I need to run a macros, and I'm not sure where to begin.

View 3 Replies View Related

List Of Random Numbers That AVERAGE A Predefined Number

Mar 13, 2007

I want to create a long list of 10,000 random numbers between -100 and +150, but do it so that the average of all the random numbers equals 20.

View 9 Replies View Related

Extracting Strings From A Column Of Data That Match A Predefined List

Jun 15, 2009

I sent this before but the formula I was given wasn't correct (as you will see from the file). In Column B of the second sheet (Data) of the attached file, I want to bring back the relevant name form the first sheet (List), which involves searching through the long descriptions from column A on the Data sheet for the name on the List sheet.

View 2 Replies View Related

Randomly Pairing Wrestlers In A List?

Nov 23, 2013

I want to be able to input wrestlers names and pair them up for 2 matches randomly. Is there any way to do this? I am not advanced in excel, but not a novice either. I need to make sure they don't wrestle the same people in each round. Also there will be wrestlers from the same team, so is there any way to try and not pair them together unless it is necessary?

View 2 Replies View Related

Randomly Pick 1 Set Of Initials From List

Apr 22, 2012

cell a1 is blank
cell a2= "sb"
cell a3= "db"
cell a4 is blank
cell a5= "rm"
cell a6= "kw"

I want to randomly pick 1 set of initials from the 4 listed in the 6 cells and put the result in cell a7.

View 1 Replies View Related

Sorting A List Randomly, And Fairly.

Jul 17, 2007

I have a list of potential competitors in an event, and am using both RAND and ROUND to sort them into a list of 1's and zeros. My formula is as follows: =ROUND(RAND()*1,0). My problem is that I get an uneven distribution of players, out of a list of forty, I may have 38 people that are 1's and 2 people that are 2's. I'd really like the list to be randomized, but evenly to allow for fair competition.

View 3 Replies View Related

Randomly Sorting List Of Numbers Into Different Permutations

Mar 1, 2014

with this problem (which I've been trying for weeks to solve).

I have a column ("C") of 640 numbers, which I need to randomly sort and place into the adjoining (ten thousand) columns. I then need to correlate each of these 10k columns with column "B".

The problem I have with the attached (which works for small numbers), is that when I increase the table size to 640 rows and anything more than a dozen or so columns, it takes forever to calculate and Excel often crashes.

random ver 1.04 280214.xlsx

View 1 Replies View Related

Randomly Select One Of Two Cells To Populate From List?

Oct 16, 2013

I am wanting to randomly select one of two cells and then populate that cell from a list I have on a different sheet.

View 1 Replies View Related

Randomly Display Text From List Without Repeats?

Dec 11, 2013

I am trying to create a schedule that will randomly populate with names from a list. I have learned how to do this with numbers. How can I do this with a list of names? How can I make sure that no names repeat?

In one column, I used =RAND()

In the cells where my numbers display, I used =INDEX(ROW($A$1:$A$24),RANK(Z17,$Z$1:$Z$24))

View 1 Replies View Related

Command Button To Randomly Pick From List Of Names

Aug 17, 2014

I am trying to create a quiz for myself for studying a foreign language. and I am trying to create a command button, so that when clicked, it will randomly pick from a list of names (located in another sheet) and place the name in a desired cell.

View 9 Replies View Related

Randomly Select Varied Amounts Of Data From A List

Sep 10, 2008

I have a list of people in column A and a list of Cities that they have visited in column B.

I need to check some of the cities they have visited monthly but don't want to check them all.

I have attached a sheet as an example (this has been scaled down).

The number of cities i want to check for each person varies each month depending on how many cities they have visited.

For example, John has visited 16 cities and i want to check 5 of them. I therefore want 5 random cities that he has visited to appear next to his name at the top. The real list of data is massive so this would be really useful if it is possible.

I have looked at rand but i can't get it to randomly give me more than one city, and i don't understand how to get it to give me say 5 cities one month and say 8 cities the next month purely based on a formula from another cell.

View 9 Replies View Related

Named List: Data Validation To Restrict The User To Only Selecting Values In A List

Jun 15, 2007

I'm trying to use data validation to restrict the user to only selecting values in a list which I create. Right now, the list is a named range. I'd like to get rid of the range and just use a named list. I create a name using the following as my list.

Insert > Name > Create
Name: Fruit

Refers to:

When I try to use the name Fruit in my data validation, I get the message "The List Source must be a delimited list, or a reference to single row or column." I thought my name "fruit" was a delimited list.

View 4 Replies View Related

Produce A List Of Text, After Selecting From Validate List

Jun 5, 2009

i want to do is, have a list that picks from a color and then beside it, it will show the possible fruit that is that color for example




The number of fruit will differ by the color so i know i need a counter there, but i am not sure how to list the fruit after i've picked the color

View 6 Replies View Related

Math Worksheet For Kids/Children

Apr 12, 2008

attempting to utilize the powers of Excel to generate a math worksheet for my children. I have no experience with macros and I have only used the basic functions and formulae.

Basically I need assistance in designing a worksheet where I can input the number of problems I want displayed, the type of problems (add or minus), and the number ranges for the values. With a subtraction problem, I want the formula to make certain the top number is not lower than the bottom number. Also, I would prefer that the worksheet maker does not generate duplicate problems. Once generated, I have the option to print the results for the kids to take with them or sit on the computer and enter the values - whereby Excel will instantly turn color the answer cell green for a correct answer, and red for an incorrect answer.

View 9 Replies View Related

Excel 2007 :: Protect Template But Not The Children?

Jul 24, 2014

Using Excel 2007. When I put password protection on the template, the template child doc also gets the same password protection. I want to prevent tampering on the template, but I want the child doc to be fully editable for the end user. After all, isn't that the purpose of a template? I just don't want anyone to be able to edit the template itself, which also seems like the purpose of a template. Am I missing something about not seeing how to configure this obvious functionality?

View 1 Replies View Related

Changeable Master Form To Update Children?

Nov 11, 2008

I'm currently working on a form to fill out in a study on different analyzers; the master form has gone through several revisions. To keep things looking neat, all the "children" forms have had to be altered, too. The amount of data is getting large and having to do this is getting annoying.

Is there a way to create a master form that is modifyable where the changes are spread through the children? i.e. if I insert a row with new information, I'd like the change to occur on multiple sheets. If I move a row to a different spot, similarly, I'd want all my forms with data to move around to follow suit.

View 4 Replies View Related

Randomly Select Four Names From List Of Names

Jan 22, 2014

I need to create a function that selects 4 names randomly from a list of 15 names and displays the 4 randomly selected names in the one cell. Also, you cannot repeat the same name in that cell, (i.e. bob cannot be selected twice in his group of four)

View 1 Replies View Related

Selecting From A List To Change Another List

Aug 3, 2006

if it is possible to have a selection from a list change the list for another cell?
For example, if I have a drop down list in A1 which is "Apples, bananas, pears", and I select "Apples", is it possible for A2 to have a list of "Green, Red, Yellow", and if I select "Bananas" in A1, for A2 to have a list of "Yellow, Black, Blue"?

View 2 Replies View Related

Selecting From A List

Dec 15, 2007

I have a table of adressess and clients with contacts ie


in the list there are about 300 entries.

what i want is to put an S in the select column on those clients i am due to visit and then these records to be exported into say a word doc to print off so i have a list of visits i have to do with company contact and addresses

View 10 Replies View Related

Choosing Parent Selection From Listbox And Have It Automatically Select Children Selections

Apr 22, 2013

I have a listbox with a state and below it several cities. For example:

New York
New York - New York City
New York - Nassau County
New York - Westchester
New Jersey
New Jersey - Newark
New Jersey - Monroe County
New Jersey - Passaic

I would like to select the state and have it auto select all of the related cities including the state. So if I select New York,

It would look like this, where all are highlighted (as if selected). I coudln't find the highlighter on the thread tool bar:

New York
New York - New York City
New York - Nassau County
New York - Westchester

View 9 Replies View Related

Selecting All Rows With A List Of Keywords?

Mar 15, 2014

I have a list of Products in my Excel file, I am trying to put them into categories easily. So what I am asking is there a way to select all rows with a certain key word in them so I can easily paste them into my other excel file?

View 1 Replies View Related

Selecting Dropdown List From Webpage Using VBA

Jul 22, 2014

I am trying to select dropdown list from webpage dropdown button

Below is the html code I am looking at:

In the above code, i want to get the dropdown value into excel sheet

below is the code i m trying to use but not working.

Set ElementCol = objIE.Document.getElementsByTagName("Select")


View 4 Replies View Related

Selecting Multiple Items From A List In One Cell.

Feb 10, 2010

Is it possible to restrict the values of cells in a particular column to entries defined in a list BUT to allow each cell in that column to display multiple items from the list (seperated by a comma for example). I've attached an example of what I would like to do -

In Sheet "2010 Data" I want to be able to select multiple values in column F....(the values are defined within the list named "Platforms" on the worksheet called "Lookups"

View 4 Replies View Related

Selecting Rows In Table Based On Another List?

Jan 30, 2013

I have attached the data in an excel file here. I'd like to select (or highlight) the rows (based on names) in the table on sheet1 based on the list provided in sheet 2. I've been struggling with using a formula for this one. The list on sheet 2 may be longer than the table on sheet 1(since there are entries on the list which might not be present in the table column 2), and the reverse may also be true. I would like to select "entire rows" of names in the table that are there on the list on sheet 2, not just the names column in the table. See the desired result on sheet 3.

View 9 Replies View Related

Sending Email By Selecting From A List Of Addresses

Dec 2, 2008

I am attaching a workbook with the VBA code for sending email.

I found the code on this forum and changed a little bit to make it work for my application.
I am not sure if this is the most effective way, but it works.

The user would select from a list of names on sheet1 and click "send_mail" button. What I need done is to send sheet2 as an attachment.

The problem: The code is looking for address in cell "H7" on sheet2. I want to keep the address on sheet1, but send out sheet2.

If I copy the address from sheet1 to sheet2 in cell "H7", everything works fine. So I need soemone to help me change the code, so it will send out sheet2, but read address on sheet1.

View 9 Replies View Related

Populating A Worksheet After Selecting A Drop Down List Entry

Aug 31, 2009

I currently have a huge data sheet with multiple columns of information. It contains a list of projects organized by columns with information pertaining to each project. I've named this worksheet data.

On another sheet I've named Present, I'm trying to find a way to reference a single project at a time using a drop down list. The Present Sheet has a list of characteristics fields that need to be filled with information from "data" worksheet. I want the characteristics to change whenever I choose another project name from the drop down list.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved