generator

Hi, I got a list of my employees from A1:A72, we got a game where in I need to display a single employee name without being repeated. So, that particular employee can perform the task. Or to be more exact the list is already jumbled can I display a single employee name one after the other in...

I have the following list in an excel sheet Column A Red Green Blue White Black Question : I’m looking for a script of some kind that will create a permutation of all these words that’s possible without repeating. However, with minor thing the items of red and green must be...

Hi all, I could use some help. I am familiar with Excel but not extremely skilled at it. I am in need of a template that could generate a football lineup based on # of practices attended and favorite position. Basically, there are two practice days in the week, some players don't attend both...

Afternoon... I have created a Purchase Order Generator, and now I need to log the entries on the purchase order to another sheet before I clear the purchase order for new data. I can get it to update and copy to the log, but it keeps over writing what I did rather than creating a new row and new...

I have a list where I want to put it to "Last Name, First Name" but if they have multiple words in their last name, I only want the last part of their last name to ensure that I won't have any errors when I'm performing a check as some reports don't put the full last name. at the moment I have...

Hi everybody I have generator password in excel, but sometime, my password have dulicated character, which make my password less secure, can any one help me with the fuction to help my password not have a dulicated character. My password is in G1, the ingredient to make my password is from D5 to...

I have the following data excel code that looks at a sheet of data and sorts the data based on a number and copies it to a new template sheet. A B C............ Line: 51106-02 AB ZONE 51106-02-904-601...

hi all, I am creating a PO generator and excel I need support. 1. I want to generate PO number in the format as ex: companyname/projectdescription/Projectcode/SLNO like ABDC/CSM/AA456/001. here variable is project code , projectdescription,SLno. this PO number has to trace the last PO number...

Hi All, I have created a Random Number Generator using the code below Private Sub CommandButton1_Click() Range("d2") = WorksheetFunction.RandBetween(-2, 2) Range("d3") = WorksheetFunction.RandBetween(-2, 2) which works exactly how I want it to What I would like to do from here is generate a...

Hi I’m looking for a random number generator. If the customer has not supplied a Tax number/National insurance in Column A then a random number will be placed once the VBA is run, it will also highlight the whole row, in red. There can be no duplicates Its will be as TEMP12345678 If a tax...

I am trying to create a random text generator but I need the following chances assigned to the following letters. C = 20%, I = 70% and P = 10%. These variables will change with each new block but if I can get help on the first part I will know what to do. I do know that I could use the...

I would appreciate any thoughts regarding a user defined report generator. Would prefer to buy, or get one free. tia Jack

I have an if statement =IF(D2="","",TODAY()+2) but I wanna change it so if D2 is a nonzero, the cell will produce a lot number with a format of mmddy202P. 202P is a standard ending for the LOT Numbers. I was also hoping that the year will only have one digit (end of the year digit: 2017 =7). So...

Dear all Excel Professionals, I am a total newbie to excel and wants to know if it is possible to have a auto generator for the grouping. I have 8 games, max. for 36pax (sometimes will be fewer to 18pax). I will have 4 groups to do the same game at the same time. I hope to make a auto...

Thanks for taking the time to read this thread, I am new to the site and although I have searched on here, I can't find an answer to my question. I have a 'Formula Generator' in excel that generates a 14 digit Password in a cell. I want to be able to copy this directly from Excel and paste in...

Hello, I am using microsoft office excel 2013. I have googled everything I can think of and all I can find are ways to create barcodes from numbers I type in. I am trying to see if it is possible to generate barcodes with random numbers so that it will not create duplicate barcodes. Maybe if it...

I'm looking to make a workbook generator in VBA which creates a new workbook, copies and pastes a template from sheet1 of the original (select all and copy paste), and then takes data from sheet 2 which is organized in a list and pastes it in a corresponding cell. This script would run down...

Hello All, Since the Code93 barcode generator has been developed I've been thinking of Code128. And finally I've developed it! As before want to share it with other Mr.Excel users and Google searchers. :smile: It was much easier and faster than Code93 as Code128 is simpler to encode and yet...

I need to figure a way to make say cells A1 thru A10 produce random numbers from 0 to 9. I would like to do it without a macro if possible. I also need a button to generate those random numbers. I know this button may make it impossible to not use a macro, but let's see if someone can. If it...

I have made a work order template in excel and would like the work order cell to increase in value each time i create a new work order. Any and all help would be greatly appreciated.