Serial Number Generator For Document (application Form)
Feb 13, 2014
I have made a Excel base "Application form".....it is a master copy.
I want to send a copy to a client....which has a unique serial / code number e.g. IF/001/2014.....
Presently, I am doing it manually, as application send to many clients...it become a hectic job to remember / note down the serial number....
I am trying to use a "Active X control" button to generate the desired serial number.....
There may be five categories.... IF, IA, OGG, WC, TU respectively.
I want five button to perform this job....
View 2 Replies
ADVERTISEMENT
May 30, 2008
Does anyone know of an Excel macro or function that can generate say 1000 strings of 6 numbers from 1 to 49, without repeating the same combinations?
Kind of like the random picks that lottery machines generate.
View 9 Replies
View Related
May 12, 2007
I have a range of cells that have values from 1 to 7 in them. What I would like to do is to have the next column generate a random number from 1 to 7 that does not generate the number that the cell next to it has. for example if cell A1 has 6 in it, I would like cell b1 to generate a random number other than 6 in it. if cell A2 has 3 in it then cell B2 would generate a number other that 3 (1,2,4,5,6, and 7).
View 9 Replies
View Related
Oct 9, 2008
how to create a basic random number generator within an excel spreadsheet?
Basic Lower limit = 0
Basic Upper limit = 100
View 9 Replies
View Related
Jan 27, 2009
I have 4 names, and a grid of 100 boxes. I need those 4 names randomly deposited in the 100 boxes, making sure each name is displayed an equal number of times (25 each) Is there an Excel formula to compute this?
View 9 Replies
View Related
Feb 27, 2007
What I'm trying to do is as follows:
Sheet 1
A1 through A6 has STR, DEX, CON, INT, WIS and CHA. B1 through B6 is waiting for results from sheet 2.
Sheet 2
A1 is data validation of d4, d6, d8, d10, d12, d20 and d100. A2 through A7 are currently Rand formulae triggered by A1 with B1 adding number of dice (minimum 1) and B2 a modifier value add to the rolled result. D2 through D7 are data validation modifiers of -10 to +10 (0 included). E2 through E7 is the result of A2+C2. The Rand works fine, but every time data is changed Rand recalculates. I'm hoping for a macro executed by a button to generate six random numbers based on the chosen die value of A1 ranging from 1-4 to 1-100. The die roll can never be below 1 and no higher than the chosen die. I then want to transfer the result from E? To sheet 1 B1 to B6 matching its appropriate atribute. I named them Char01_STR, etc on sheet 1 A1 to A6.
View 9 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 1, 2014
I have code that generates random numbers 1 - 90, what I would like is when the command button is pressed the numbers are generated every 5 seconds, I have attached the workbook.
View 5 Replies
View Related
Nov 27, 2013
I have a set of data with index numbers and the percentage of their occurrence. I want to use this percentage to weight the occurrence of the index numbers and create a random list of say 500 occurrences.
Index %
1 7.95
2 3.28
3 7.37
4 38.45
5 28.62
6 14.12
View 8 Replies
View Related
Aug 27, 2012
I have coming from the Forms Controls within a Sheet 6 CheckBox.
for the following countries: "Spain", "France", "UK", "Italy", "Germany" and "EUROPE"
when Europe is selected the I select all the Check Boxes at once by Macro, if Europe is selected and I unselect Europe, then I unselect all the countries by Macro.
When Europe is selected and then I press for eg in Spain, the Spain is not selected and then I unselect Europe, by macro.
This works fine, and my macro does the job OK.
Code:
Sub mCountries()
On Error Resume Next: Application.ScreenUpdating = False
Dim wCaller As String: wCaller = Application.Caller
Dim aCheckBoxes(): aCheckBoxes = Array("cBoxSpain", "cBoxFrance", "cBoxItaly", "cBoxGermany", "cBoxUK")
Dim X As Long: X = -4146
Dim Y As Long
[Code]....
But if My 6 CheckBoxes are grouped... the Macro does do the job How can I refer to a shpes withing the Grouped Shape to apply the selection and/or to unselect??
View 4 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
Sep 10, 2007
how to go about generating random numbers based on Weibull distribution in VBA? I had a rough idea for Normal (from link below) which i later extended to Lognormal but am having difficulty with Weibull and Gamma will appreciate any help.
http://www.devx.com/vb2themax/Tip/19233
View 9 Replies
View Related
Oct 29, 2009
I would like to get random number generator for normal distribution and I’m using:
=NORMINV(RAND(),$B$1,$B$2)
Where B1 is mean (average) and B2 is SD.
This command works, but in the random generating numbers, I’m getting positive and negative numbers (ex. -23,34).
how to change command so I can generate positive only numbers?
View 9 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
Apr 8, 2014
I want excel formula to calculate the sum the value of partused depends upon serialno repeats where repeats of end of serial no i want result at end of every multiple serial no end cell.
View 2 Replies
View Related
Apr 23, 2014
I am trying to do with this spreadsheet project,
On the "Master" tab, I would paste in the newest information received from our system weeklywhich is around 2600 rows. I want to then compare the Master sheet to the other tabs and if there is a new Serial Number present in column I, then add that row of data to the next available row at the bottom to the correct tab.
The Orange tabs Fleet Volume PC, Fleet Volume BW, Fleet Volume Duplex will house all countries and all serial numbers but Fleet Volume Color tab will only have Color Serial Numbers for all countries, column J on the Master tab.
So, the same will goes for the USA Volume and CAN Volumes tab, only those serial numbers for that country will falls in these tabs and color only will go in the color tabs. There are 14 other tabs missing from this workbook with other countries, just removed to keep size of file within limits.
From my workbook, rows 29 to 33 on the Master tab are new serial numbers.
Also, I want to highlight the data on the Master, after comparing this Master tab to the other tabs and within the Master highlight in yellow the cells that have new updated information!
View 14 Replies
View Related
Feb 1, 2014
I have a excel file to print label on a label printer.I've added additional file in this message.I'm printing different numbers of labels with this file.for example, if I print 10 pieces of labels, I want to write 1/10 , 2/10 , 3/10 etc. on each label.I finded a vb code to print this work but not exactly the way I want.I would ask one of excel guru's to look at my file.
View 8 Replies
View Related
Dec 11, 2006
I need a macro to insert a new row with incremented serial number in column A, when done the first time - to insert the row at a specified cell starting with serieal no: 1 and later to insert the new row after the last row. Also I need the macro to insert certain pre-defined text values in specified cells in the new row..
View 11 Replies
View Related
Jul 28, 2012
I need to lookup the last date coupled to a serial number but with vlookup it takes the first serial number from the top of the database. Is this at all possible?
View 3 Replies
View Related
Feb 7, 2013
I need to convert a date into a serial number. The serial number must return the format DDDYYNN where DDD is the day of the year, YY is the year, and NN is the sequential build number. As an example, if 10 units are built on 2/6/2013, the serial numbers would be 0371301, 0371302 ...0371310. Cell A1 would contain the current date (2/6/13) in this example. Column B1 - B10 would be the sequential serial numbers generated by the formula.
View 3 Replies
View Related
Jan 5, 2009
I have been trying to type a date in a column in MS excel. But excel always reads it as a serial number.
How Can I get it to display the date as it is in date format. I have the next column formatted/ formulated to display the day of the date in the previous column.
View 9 Replies
View Related
Sep 5, 2009
I have a list of serial numbers for coins I collect. As I collect the coins I wouldlike a spreadsheet where I can enter on a sheet and it will then highlight that serial number from a data sheet I have already created.
View 9 Replies
View Related
Aug 28, 2006
I'm having some trouble with copying dates from certain worksheets into new worksheets. When the data is pasted into the new worksheet, the date changes by four years. Somehow, the process of copying and pasting is reducing the serial number by 1462 units (days).
I'm not sure whether this is a bug or a security restriction to prevent copyright breaches. There's a way of getting around it, but I'm curious as to why this is happening. The dates copy and paste correctly into the existing worksheet, but not a new one. An example is attached and the dates are in columns C & D.
View 2 Replies
View Related
Nov 27, 2007
Quick question:
If I have a serial date, e.g., 37883, in Excel, how can I convert to 092007, using that exact format?
<snip by admin. Read the rules!>
View 4 Replies
View Related
Oct 6, 2008
As you can see below, I've written code that writes random numbers into three columns of a spreadsheet (10 numbers in each column).
What I want to do is create code that will run the random number generator for a period of 1 minute and then stop. I know that I will need to write a timer subroutine to do this but I'm how unsure how to do this.
View 9 Replies
View Related
Feb 4, 2014
I have a Challenge want to delete the row values in which serial no enter the textbox1.
Conditions:- find the Serial no. and delete the values except serial No.
Attaching file for reference : Example.xls‎
View 3 Replies
View Related
Aug 13, 2007
I have the following code to search for serial numbers.
Private Sub CommandButton1_Click()
Dim Message, Title, Default, SearchString
Message = "Enter Serial Number" ' Set prompt.
Title = "Find Serial Number" ' Set title.
Default = "" ' Set default.
' Display message, title, and default value.
SearchString = InputBox(Message, Title, Default)
'SearchString = "Rob"
Set S = Sheets.Application
For Each S In Application.Sheets
With S.Range("A1:IV65536")
Set f = .Find(SearchString, MatchCase:=True, LookAt:=xlWhole, LookIn:=xlValues)
If Not f Is Nothing Then
f.Offset(, 3) = Date
Exit For
End If
End With
Next S
End Sub
I would like to amend this so that (a) if the serial number is not found I get a message box saying "Serial number not found" and (b) if the serial number is found, I would like it to highlight the relevant row (after inserting the date).
View 9 Replies
View Related
Aug 2, 2006
I need to compare a S/n from a huge amount of datarows in sheet 1 with the s/n in a second worksheet.
If the s/n matches i need to copy the datarow from sheet 1 to sheet 2 next to the data allready existing in sheet 2. This removing the row from sheet 1.
If there is no match found in sheet 2, the row ha's to be copied to sheet 3, this also removing the datarow.
like:
sheet 1:
S/n -- name -- price
sheet 2:
S/n -- place -- stock
if match is found need to become:
S/n -- place -- stock -- S/n -- name -- price
if there is no match found data go to sheet 3.
View 5 Replies
View Related
Jul 31, 2014
I have an excel database where I register cases. I have in it a button that creates a folder with and ID nr that is in column A (I create new ID nr in the next row, when I press the button it will create a folder with that ID nr and inserts a blank word document in it). We have a template that we copy to the folder (depending what type of case). The idea would be that once the template is filled in and ready to print, It would take the values from the ID nr and a reference number a few cells to the right. Is it possible to tell excel to open the word document in the folder and create a PDF version with the ID nr and reference number. (there are only 2 templates, so the macro would have to look for one of the two in the folder) The names of the templates are: "Standard" and "Other". I guess the best way to start maybe this would be that I select the cell with the ID nr and then press a macro button to have this done. One thing that needs to be done, is to put a copy in the same folder and another in a second folder called "Binder" in my documents folder.
View 1 Replies
View Related
