generator

  1. T

    Excel permutations word generator

    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...
  2. A

    Generate football lineup in Excel document.

    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...
  3. B

    Purchase Order Generator

    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...
  4. M

    Take word after last space before comma

    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...
  5. P

    Password Generator in excel FILE

    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...
  6. E

    Template generator and data sorting

    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...
  7. R

    EXCEL PO generator

    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...
  8. W

    VBA Random Number Generator

    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...
  9. Sharid

    Random Number Generator

    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...
  10. C

    Creating a Random Text Generator

    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...
  11. D

    run time report generator

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

    LOT number generator - date and static text

    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...
  13. Y

    Grouping - for max. 36pax with 8 games (4 groups per game as same time)

    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...
  14. V

    Can't Copy and Paste generated password, to encrypt Workbook

    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...
  15. F

    How to creat a macro to generate a barcode in excel by clicking a button?

    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...
  16. M

    Workbook Generator based on template and data list

    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...
  17. Y

    "Code128" barcode generator in VBA

    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...
  18. C

    Random numbers without a macro?

    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...
  19. 3

    work order number generator

    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.
  20. M

    Pick names at random

    Hi guys. This is my first post but hopefully not my last. I have a query regarding a random name picker that i'm trying to set up and i'm hoping someone can help. Basically i am trying to make the placement of staff in the venue i run as random as possible. We tend to find clicks of certain...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top