Creating A Random Serial #
Apr 19, 2007
I have a mastersheet that once I open I would like to generate a 3 digit serial number in cell C22. Once this file is opened and the number is generated I do not want the number to change at that point. I have a macro to save the file with data in certain cells. Once this macro is run and the file is saved I will need to be able to open that file to view info but the serial number can't change.
I would like to do this without an add-in so that any client can use file no matter there settings if possible
View 10 Replies
ADVERTISEMENT
May 31, 2014
I have a userform for keeping records and would love to incorporate a new feature. I would want to generate a random serial number for each entry made with the userform.
View 2 Replies
View Related
Jun 2, 2006
Im an using excel to run a simulation of demand over a period of 200 days. i have an average daily demand of 7.75 and a stdev of 2.6. Is there any way to generate random numbers (for daily demand) based on this data?
View 3 Replies
View Related
Aug 9, 2013
Here's what I'd like to do:
Have 10 columns... one column would be for the "1s", another for the "2s", another for the "3s", etc...
But I don't want to have them in straight order (i.e. 1 x 1 =, 1 x 2 =, 1 x 3 =, etc...) because the pattern is easily memorized, no matter what number he's working on.
I'd like to be able to hit a button (or something) and have each column shuffle (or randomize) the order in which the equations will be displayed.
So, a column might come up 3 x 6 =, 3 x 9 =, 3 x 1 =, 3 x 4 =, etc...
And next time it might come up 3 x 5 =, 3 x 2 =, 3 x 4 =, etc...
This way he won't be able to memorize any patterns and he'll actually need to learn his multiplication tables.
View 14 Replies
View Related
Jul 27, 2014
I am looking for a product that uses excel to create a random test form a bank of questions. I have 50 questions in all and I need a random test of 35.
I can and have messed around with the following. Excel 2012
A
B
C
D
1
Random #
Test Number
Small-Sort
Random Question
I could even shorten it a bit by placing like this. MATCH(SMALL($A$2:$A$4,B2),$A$2:$A$4,0). Of course this is only the start and it would have in column B 1-50 and in column C&D 1-35 for the selection process. Then I was going to set up on sheet 2 my list of questions 1-50 and my idea was to use 1.1, 1.2, 1.3, & 1.4 for the answers to question 1 and then vlookup. so that when and if question 1 is part of the 35 random then I could pull the answers over as well. but as I started the 'animal' will get bigger and bigger fast.
View 1 Replies
View Related
Nov 11, 2013
I am creating 100 random portfolios from a list of 10 assets. I have the return history of the 10 assets and I'm able to calculate the mean and standard deviation of each asset as well as the covariance/correlation between each of the 10 assets. I want to choose to portfolio with the least variance as well the portfolio with the lowest and highest return.
Would it also be possible to introduce a limit that constrains the maximum allocation to each asset at 25%?
View 7 Replies
View Related
Mar 23, 2012
I have 800 rows of patient information, I need to sample 70 patients. I used the Random.org randomizer to get my 70 patients. That randomizer only gives me the line numbers such as 1, 8, 23, 45, 70, etc. I then need to go to Excel and just pick out the patients on those lines I was given above. Is there an easy way in Excel to have my spreadsheet of the 800 rows and create a (simple) calculation that will pick out the line numbers that I need all at once, so I do not have to go thru manually and choose the data from row 1, 8, 23, 45 etc to make my new spreadsheet with only my sample patients on it. OR is there a easy way to pick 70 random lines from a spreasheet..
View 1 Replies
View Related
Jan 7, 2010
I have some VBA (using Excel 2007) that deletes and re-creates a bunch (20-ish) checkboxes in a spreadsheet. Since i'm using the controls-based checkboxes, Excel defaults them to object names of "CheckBox1, CheckBox2, CheckBox3, etc" as I create them the first time around.
Later on, i clear all checkboxes and implement the SAME checkbox-creating code to re-create all or some of the checkboxes, but Excel doesn't number them in order the second time around! I end up with something like "CheckBox2, CheckBox19, CheckBox3, CheckBox12, etc."
What could be causing my code to create things out of order the second time around? Is there a way to reset Excel's Checkbox-numbering iterator?
The code i'm using to create checkboxes is:
Dim x As Long
Dim BoxCell As String
BoxCell = ""
x = 0
'j gets passed into the sub as a "Long" somewhere between the values of 5 and 35
View 9 Replies
View Related
Aug 4, 2006
What i would like to do is, create a random weekly work rota, so I just have to go in every week and let excel randomly but fairly creat a rota the employees so that they don't argue about whose doing what and just get on with the work. : D
View 9 Replies
View Related
Aug 11, 2014
Im looking to create random data for an athlete over about 4 months with daily tests, however when im using the =randbetween(*,*) function the data is too 'Random'. so im looking to create a trend in the data, like real athletes will have. is there a function in Excel 2010 that can do this?
The boundaries of the data are -336,416 (i know its quite a big range)
View 8 Replies
View Related
May 19, 2014
I am trying to create challenge/response cards. Each card will have a 5-digit number in the upper-left and lower-right corner along with a series of rows containing a line number and 3 pairs of challenge/response words.
Rather than have have copies of these cards, I want the central office to have a macro-enabled workbook wherein they can enter the two numbers from the card and have the challenge/response matrix regenerate on a worksheet.
So, essentially, I want the challenges random number generator seeded from one of the 5-digit numbers and the responses random number generator seeded from the other 5-digit number.
I am trying to use
Code:
Randomize(Seed)
where Seed is one of the 5-digit numbers.
The problem appears to be that, no matter what I use for Seed, the RND(-1) function is not resulting in different numbers.
I am using Excel 2007 and Excel 2010.
View 1 Replies
View Related
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
Sep 1, 2009
Have exported oracle DB data in an Excel sheet. There is a column with text and numbers in it. I need to get out the serial numbers of this text columns of up to 12000 data fields.
My problem is that the serial number is not always the same format. There might be also two serial numbers in one text field.
One cell can look as the following:
GEYSER BURST - SERIAL NO:102 15712, 10 AUGUST 2005,150 LITRE SUPA-FLOW, EASILY ACCESIBLE. App made for today as per Victor ( Notes by Pamela on the 18/07/2008 13:30)
Out of this cell the Serial No is 102 15712.
There are other formats like:
550501 009879
H 100107452
H100/110230
Sometimes there are only four or five numbers or there are special characters between the numbers like - or /.
I would like to seperate these serial numbers in a seperate cell. There might be also a cell without any serial number in it.
Is there any other way to get these numbers out except of doing it manually?
View 11 Replies
View Related
Dec 5, 2007
is there a VBA that can protect the workbook by the computer serial Number .. so it won't work on another pc than this?
View 14 Replies
View Related
Sep 20, 2007
I am receiving the data from the client , I want the serial no with the day of the date ... like this .. i ope u got it..
Like
thu01 20-Sep 2007
thu02 20-Sep 2007
thu03 20-Sep 2007
thu04 20-Sep 2007
Fri01 21 Sep 2007
Fri02 21 Sep 2007
Fri03 21 Sep 2007
Fri04 21 Sep 2007
Mon01 23 sep2007
mon02 23 sep 2007
I may receive more that 100 mails in a day .. so the serial should get updated of its own.
View 9 Replies
View Related
Oct 29, 2009
if there is a macro for import a serial data into a excel cell!
View 10 Replies
View Related
Jan 22, 2009
I have a dynamic list of items which I have to assign serial numbers to.
If the serial numbers go in sequence, it would have been easy.
But the problem is, they don't.
They go from A1 - A9, B1 - B10, C1 - C10 ....
Is there a way I can assign an array to ensure that once the macro hits A9, it starts from B1, and once it hits B10, start from C1?
View 9 Replies
View Related
Feb 13, 2007
I have to create item code (col B) based on emp id (col Q). If emp id 9999 appears 3 times, the item codes should be 9999_1, 9999_2, 9999_3. If Emp id appears only once, item code = emp id. How do I achieve this?
View 6 Replies
View Related
Mar 22, 2007
I was just viewing the VBA to "get a hard drive serial" and would like to know how I can make the serial appear in a cell?
Sub SerialNumber()
Dim oFSO As Object
Dim drive As Object
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set drive = oFSO.GetDrive("C:")
MsgBox drive.SerialNumber
Set oFSO = Nothing
Set drive = Nothing
'release memory
End Sub
View 3 Replies
View Related
May 31, 2007
I have a worksheet(sheet1) that contains, among other things, a column of serial numbers . I also have a separate worksheet(sheet2) with one column of the serial numbers I want to find in sheet1. I need a macro that will take the serial numbers from sheet2 and find them on sheet1(there are duplicates too) so I can copy them to yet another sheet(sheet3). I already know how to do the copying, but am lost on the search.
View 3 Replies
View Related
Jul 15, 2012
I want S. No. in Piovt Table like
If I collapse Date then S. No. Main should work. Althought, I'm doing this manually by unchecking blank cell in "S.
Sr.No.Pivot.xlsxMain" and If I expand then Sub S. No. should automatically expand. Is it possible in Excel Pivot Table ?
Manual S. No.
S. MainSub S.# DATE CORES_NO.
1126-Mar-12
227-Mar-12
328-Mar-12
429-Mar-12
251-Apr-12
65-Apr-12
7
8
9
310
11
12
413
14
15
516
View 10 Replies
View Related
Sep 23, 2008
I have searched high and low for a macro that can move cell values to other worksheet based on a variable serial number. I have had limited luck with my search but nothing quite reflects my needs. Any help or suggestions would be great. The way that I envision it to work is simple to say but to hard for me to figure out. I must add that I am fair to good with macros; I am using Windows XP and Excel 2003.
Here is the concept:
-I am trying to track several vehicles, their status and there general locations using a variable serial number and an excel macro. The macro would execute the calculated data on sheet “My Taxi Cars” and the results would appear on a separate worksheet called “Location” that is in the same workbook. Please see attached.
-The serial number is comprised of a cell range starting at A2 thru L2 and then concatenates in M2 it would look something like this 123N1110011011. This serial number would allow me to do simple long-range analysis for each of the vehicles. Also in theory at the end of 30-day period I could “replay” my data.
The Breakdown for the alpha numeric serial reads like this:
1) The 123 is the number of the cab.
2) The “N” is for North, etc. and it would equate to a range of cells on a separate worksheet (“Location”).
3) The Ones and Zeros are just simple yes or no answers to the common questions in the Garage at work.
Once the macro is executed the result would be the taxis number (taxi number only, the rest of the number is stripped off) being placed the correct location based off the serial number. I have no idea if this is possible and I would like to thank you in advance for your help. Thanks.
I understand that there are about 1024 different combination's for a binary number that has ten place values. Maybe the answer is to use VLOOKUP or HLOOKUP, but then that changes my analysis scheme. But if you can just help point my nose in the right direction or show me with one example I can take it the rest of the way.
View 14 Replies
View Related
Jan 11, 2013
I have one page in excel to print. But I want to print it 1000 times and on each paper i need another serial number. How do I do this?
View 4 Replies
View Related
Oct 16, 2004
Sheet4 in my book looks like this:
.............A.......................B................................C..................
I......Invoice No…..…Starting Serial No……...……Ending Serial No
2…………ND12………..6011000000013652……. ..6011000000103652
3…………ND13………..6011000000116526……....6011000000246977
4…………RF4……….….6006000001255724……..…6006000011249564
5.........RF4...........6005000000023652.........6005000000095624
note that the last 4 numbers of the series are randomly generated for security reasons and are not part of the range of the the serial No’s
So Invoice ND = 10 consecutive numbers, Invoice ND13 = 14 and Invoice RF4 = 1000 and RF4(again) = 8
The list on this sheet is a mile long
What I need is a “search box” with two windows in it
In one box I will type a serial number and in the second box I will get the Invoice number
The challenge is that the serial number could be between Starting and Ending serial No’s thus if I were to type serial number
6006000001086598 in the first box the answer in the second box will be : RF4
View 9 Replies
View Related
Nov 20, 2008
I have in my sheet from C13 to C350 many serial numbers which I manually type them in. These serials are 5 digit numbers, and I was just wondering if there's a function or formula that will not allow duplicate numbers in that column.
View 9 Replies
View Related
Jan 13, 2007
That is what my spreadsheet looks like. I have about 130 in the sheet I'm working on now. A is my date cell, B is my total for that date, C is the cell I have made for the =Month(serial_number). The problem i'm having is how do I get it to not put a number in my "C" cell when there isn't a month present?
This sheet will change weekly, so I've went down to 300 with my month formula. When entering the formula in the cells that do not have the month, it automatically inserts a 1 that throws the count off for my entire sheet. How can I leave the code for my month in without having it add a number when there's no month?
View 5 Replies
View Related
Oct 3, 2013
I am trying to get Excel to write a series of incremented serial numbers to an external program.
I need 10 per line, then for the code to send ENTER and start writing on the next line. Following is my current code:
For i = 0 To qty - 1
SendKeys prefix_sn & next_sn + i & ","
Next i
View 6 Replies
View Related
Aug 4, 2014
I have a spreadsheet with a list of about 3800 lines of dollar values in "K" that correspond to various serial numbers in "E".
These serial numbers come up multiple times at different place throughout the 3800 lines.
I know by using SUMIF I can calculate the total value of each serial number, but is there a way to bring the serial numbers across to correspond to the sum of the dollar values?
View 5 Replies
View Related
Apr 16, 2014
I have repeating 7 names in A column.(Like a name group)
Each group names repeating after a blank(empty) row.
I want to write to B column for each repeating names from 1 to 7 as number value.
View 2 Replies
View Related
Dec 16, 2008
I maintain a class register in Excel to monitor student attendance. The first row shows the date of the class in the form dd-mm.
I need to identify all dates which fall on a Monday and thought that if I custom formatted a new row as "dddd" and enter the formula =DAY(cell ref) into the cells of this new row it would achieve this- I could easily spot the Mondays for the period under review.
What I'm finding, however, is that the formula seems to incorrectly state that 16th September 2008 is a Monday whereas it's actually a Tuesday- utterly bizarre!
I can get a fix simply by modifying the =DAY() formula by adding 1 to my formula [ie =DAY(A1)+1] but am wondering is this a "so called known issue" with Excel or has anyone else come across it? I have never previously come across this and consider myself to be an above average competency level user of the application.
View 6 Replies
View Related
