Random Input

Feb 26, 2009

First time poster, long time viewer for help.

this one should be an easy one for you experts.

i am in charge of making an assignment list in my classroom .

cells A1 all the way to A20 have a single childs name in them.

in the corresponding box ,B1 which is next to the first name and B2 next to name 2 , etc etc. i would like to put 3 random chores they need to do for the week. the first chore being in column B the second chore in C and thirs chore in D . in other words, each child listed in column A , 1-20 will have 3 chores to do over the week .

all 3 chores for each child will be in the same numbered row as their name.

i have a list of all the chores at the bottom of the spreadsheet, theyre from A20 to A40 (20 chores in a row) . i want excel to randomly put A20-A40 in the corresponding boxes next to the kids names.

im tired of having to mix all their chores up for the week next to their names.

View 10 Replies


ADVERTISEMENT

Random Option Selection Based On Variable Input

Jul 23, 2009

I need an action to allow for the random selection of a predetermined series of number codes which represent a given letter.

It is probably easier to look at the attached sheet and the previous discussion to see what I mean.

Previous discussion:
http://www.excelforum.com/excel-work...-of-cells.html

View 2 Replies View Related

Generate Random Numbers In Random Cells

Sep 18, 2009

I am working on a Random Cycle Count Generator that provides random SKU#s based on 3 separate columns of SKU listings. The user clicks a button to generate the SKU#s to cycle count for that day. What I would like to see is a date stamp in the columns next(B,D,F) to the referenced SKU listing(A,C,E) based on which SKU#s are generated. This will let me see the last date that the SKU was generated. I would also like it to automatically save after generating.

View 2 Replies View Related

Input In Multiple Cells To Generate Input Into Single Cell?

Feb 22, 2014

I have a spreadsheet with 5 columns. A1 to A5

Entries are made into columns A2 to A5 but only ever one entry across all cells

If an entry is made into A2 to A5 the I need a "P" to be placed into A1

View 4 Replies View Related

Input Box To Create And Input Info Into A Formula Which Then Populates A Cell With A Value

Jul 24, 2014

I am trying to create a macro which gives me an input box. I need to enter 2 numbers into the input box. It would be as follows:

Input Box Msg 1 - "What is your labor cost?" (NUM1)
Input Box Msg 2 - "What is your productivity rate?" (NUM2)

Then I need the macro to take this info and enter it into a formula which changes according to the row which you are on. (I need the macro to work based on which ever cell I currently have selected). The formula would be this if I currently had a cell on row 10 selected:

=(NUM1*(NUM2*$H10))/$H10

So, if I currently had cell L10 selected, and I ran the macro and put 100 in for "NUM1" and 10 for "NUM2" and my sheet had 20 in cell H10, then the macro would enter the number 1,000 into cell L10. If I had L500 selected, then the macro would enter the final number into cell L500 based on what value H500 contained.

View 9 Replies View Related

Transferring Of Input From Input Cell To Output Cells?

Jun 8, 2014

I would like to know if it is possible to transfer values of cells this way?

I've attached the excel file for easier reference.

View 3 Replies View Related

UserForm Input (a Button That Opens An Input Box Or Dialog Box)

Jul 4, 2006

I have to design an input user form (a button that opens an input box or dialog box), which asks user to "Enter number of "columns"".

User enters a number i.e. 2 or 3 etc

It then asks user for the headings of these coulmns and places first column heading in A1 and second column heading in B1, third in C1 and so on ...

View 9 Replies View Related

Input Text In Given Cell After Any Input In An Area

Feb 28, 2007

I am just starting to get my feet a little damp with VBA and I am trying to make a macro that will act whenever any text is entered in any cell within a 3x3 square. Whenever any text is entered in any of those cells I would like it to enter a text ( "X" ) in a cell which is specified by a cell in the spreadsheet (this cell will output which cell the macro should write the text in in this format "A:1" or "C:3"). How can I make the program act only in reaction to the user entering thier text, and also, how can I get the macro to read A:1 and enter the text into that specific cell? Any help would be so awesome, the book I have is really difficult to navigate.

View 9 Replies View Related

How To Change An Input Box Based On Input In Another

Dec 9, 2008

What I am trying to accomplish....

If the input changes in D5, K11 will reset to $0.00..

Example. If cell K11 is set to $300.00, and the corresponding input in D5 is '123', when I change the contents of D5 it sets K11 back to '0.00'.

View 9 Replies View Related

VBA To Automate Text Input Into Input Box

Feb 6, 2014

I am in need of VBA code so that I can fill out an input form generated by someone elses macro input box. (I am the user, not the one developing the input box).

I am working to streamline a whole cluster of macros and this input box is currently my bottleneck. When the input box pops up, instead of me manually typing, I want to autofill the space with "104" and then click 'ok' uisng VBA.

I can not modify the actual VBA that created the input box (ie make 104 the default) because other users need the box to be blank.

find out how a developer would change the original vba code, not how a user can interact with an input box by using vba.

View 3 Replies View Related

Input Box Allow To Input The Column Number

Dec 5, 2007

I want to create an input box that will allow you to input the column number it should start in... so instead of it being fixed at A, you can choose column B, C, D all the way to the end if you like.

Sub SplitSheetsNoDelete1()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim Lmainsheet As String
Dim Lrow As Integer
Dim lcontinue As Boolean

Dim LColamaster As String
Dim lcolatest As String

'Retrieve name of sheet that contains the data
Lmainsheet = ActiveSheet.Name

'Initialize variables
lcontinue = True
Lrow = 2.....................................

View 9 Replies View Related

All Possible Random

Aug 18, 2007

I have eight teams and i want them to play each other i.e

1 v 2
3 v 4

and so on till all teams have played each other, can i do this randomly

View 9 Replies View Related

Sum Up From Random Table?

Aug 1, 2014

Since the range selection is going to be changing at time intervals( automatically), they can not be pre -defined( as above in g2,h2)

Suppose we want to know the sum of all the values against 11(now which is described as =g6 in cell J2),

HOW DO WE SET THE RANGE (E6:H11) ?

( AUTOMATICALLY, SUBJECT TO CHANGING THE SELECTION G2,H2 WHICH WILL THEN BE SOMETHING ELSE(EXAMPLE G2=1 TO H2=5)

View 6 Replies View Related

Random Number

Dec 10, 2006

How do I make a row of 5 random numbers in A2:A6 that are not the same as each other. It's basically for a Bingo card. I have a formula that can calculate the random numbers =INT(RAND()*15)+1 under the B's for example, but I can't seem to figure out how to make it so they are not the same.

View 14 Replies View Related

Random Name Generator

Jun 20, 2009

I'd like a spreadsheet that pulls out a random name.

I'll put in a lookup table, George, Fred, Ralf, Steve, Peter.

Sometimes Fred will come up, sometimes George will.

View 14 Replies View Related

Random Number In VBA

Oct 13, 2009

How can I make sure that I can generate random numbers that don't repeat using the rnd function in VBA.

View 14 Replies View Related

Random Numbers (1 To 40)

Sep 9, 2005

What do I need to do please to have a number in a row 1 to 40 as an example below

1,23,9,25,33,40 each row needs to be 1 to 40 but number no more than once
six rows deep yes the other rows can have the same numbers as above or below

=INDEX(ROW($A$1:$F$10),RANK($H1,$H$1:$H$60))

=RAND() copied H1:H60

View 14 Replies View Related

How To Set Up Random Name Generator

Jan 22, 2012

I need a formula that generates random names that i have in column a (a2:a30) I need the name to be in b1 to j1 there can't be any duplicate names

View 3 Replies View Related

VBA Random Name Select

Dec 12, 2012

I have been thinking about a name selection tool that would automatically pick a few names for internal audit. I can handle the useform launch and other basics but here is what I see happening.

1. The empname! sheet contains a list of all the company employees, with employee number in column A, names in column B and an "X" or blank in column C.

2. The main sheet called auditmaster! contains nothing currently

3. When the code is ran the userform prompts the user to select how many individuals to audit by entering an integer in a textbox.

4. If the user selects 5 for instance, the code will run and will select 5 random employees for internal audit. It does this by first checking column A of the empname! sheet and seeing what the highest and lowest numbers are. This would create the range for the random function.

Next if there is an "X" in column C of empname! sheet, those employees numbers are excluded from the random choice.

Following this the function will select the appropriate number of individuals to audit using random again and place their names/number on the masteraudit! sheet.

The detail should be placed as the following, employee number goes to column F, name to column G. Starting with row 10. The code should also number the results 1 - however many were selected for audit in column E.

View 2 Replies View Related

VBA For Random Numbers?

Apr 6, 2014

How can I use a macro on a button in SHEET 1 to generate random numbers on SHEET 2 as follows?

Cell A1: (1-10)
Cell A2: (1-6)
Cell A3: (1-100)
Cell A4: (1-12)

I've got it working with formulas, but every time I press "DELETE" the random numbers jump to new values.

View 1 Replies View Related

Random Numbering

Jan 30, 2007

I have a list of names in Column A going from row 2 to 15. I want to randomly assign them a number ranging from 1-14, but that random number can not be assigned twice. I only need each number once.

I am putting the formula in column B.

View 9 Replies View Related

Random Numbers ...

Aug 13, 2008

I have had some difficulty searching this on the web, but how would I generate a random number between 1 and n?

View 9 Replies View Related

Random Select.

Sep 14, 2008

I want to random select one of the following,red,yellow,blue,green,orange & white. (as text) in cells A2:A1001.

View 9 Replies View Related

Random Draw

Dec 1, 2008

I was looking for some code to randomly generate a number for a prize draw I am doing. I found a great piece on this site, which I have slightly changed to give me what I have below.

It works great except for one thing I cannot work out, I have the code below working on cell "C1", I would like it to work in cell "C5", but I can't seem to work this out.

Sub SlotsNum()
Dim w As Long, x As String, y As Long
Randomize
x = Format(Int((Range("B2") - Range("B1") + 1) * Rnd + Range("B1")), "0000")
For y = 1 To 1
For w = 1 To 250
Range("C" & y) = Int(8000 * Rnd)
Next w
Range("C" & y) = CInt(Mid(x, y, 4))
Next y
End Sub

Also, whilst here. i will have one other problem, with it being a prize draw I do not want to draw the same number twice. At the moment I have a small macro that copies the winning name that appears on the main screen (via a vlookup) onto a winners spreadsheet. I am thinking of then creating another macro that replaces the winning name on the master list with an "Already Won" entry, so we can just select again.

View 9 Replies View Related

Random Assignments

Oct 30, 2009

I have a worksheet that has weekly meeting dates in column A and in columns B through M different responsibilities/task. Each week, I have to schedule 1 person to perform each task. A person can only perform 1 task each week. I have a list of 40 people that are eligible to do this.

Currently I am assigning each person to a task while trying to evenly assign people and space out the timing as to how often they're assigned. Of course, being human has led my results to both favor and overlook some people. Is there a way to randomly assign any 12 people from my list into each week?

View 9 Replies View Related

Random List

Nov 25, 2006

i have entered some values in excel like this

A1 B1
1 a
2 b
3 c
4 d
etc

i will put a command button, like "Randomise"
what i wanted is , if i click that command button, the Value in cell A1 should be remain same. but the values in B1 has to be randomly changed that is, eachtime i click the randomise button the value of b1 must keep changing for every click. someting like this
A1 B1
1 d
2 f
3 h
4 a
etc

View 11 Replies View Related

Random Sorting ...

Dec 18, 2006

When I sort a list of names to rand next to it for some reason it doesnt seem to work anymore. I've done this before and its never given me problems

rand() john
rand() Jack

etc.

I sort it to the rand column

It should shuffle the names by pressing f9 but its not working.

View 9 Replies View Related

Random Shuffle

Apr 6, 2007

I am making a barrel racing spreadsheet. In Column B I am putting the participants names, in Column C I am putting the name of their horse. So Row 1 will be my header row. What I am trying to do is a random shuffle, but the participant and their horse have to stay together. Also is there a way, where I can put the stipulation, that if a person is randomly put in number 5, that she has to be at least 3 spots away from that number.

View 3 Replies View Related

Random Number Between Two Numbers VBA

Jan 3, 2014

I have build a system that needs a lot of random numbers generated to work.

I have used what I thought would work to generate me these numbers like this example:

VB:
Lastrow = ThisWorkbook.Sheets("RPlay").Range("A" & Rows.Count).End(xlUp).Row
RPlayerNum = Int((Lastrow - 2 + 1) * Rnd + 2)

This would generate a random number into RPlayerNum variable, based on the list in sheet RPlay, missing off row 1 as the header.

However we have noticed a massive flaw in this code.... It works as long as the excel file is open, each time run it gives a different random number. However if you close the excel file and open it, then run it, it ALWAYS gives the same number first run, every time.

View 3 Replies View Related

Random Number For Group

May 18, 2014

How to generate random 50 number with 10 group..

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved