generation

  1. K

    Randomization Based Off a Set of Rules

    Hi everyone, I have a rather tricky problem to solve. For each row in my table (for each person) - refer to screenshot named "My Table", I would like excel to randomly generate a 9 digit number (in Column N) but based on a certain set of rules. Here is how I currently generate them 1 by 1...
  2. A

    generation hiearchy to parent child structure

    I have my meta data in a generation format. However I need to load it to a data base using Parent child hiearchy. Generation 1 Generation 2 Generation 3 Generation 4 The World Europe Sweden Stockholm The World Europe Sweden Gothenburg The World Europe Norway...
  3. R

    Code generation formula

    <tbody> S NO CODE NUMBER MOBILE NUMBER REFERING NUMBER 1 6375871156 2 3 </tbody> Hi good morning, I need your help for making the above chart as smart. I am giving a offer to my customers, who are purchasing mobile phones in our shop. I want to give a unique offer code...
  4. I

    VBA Help? List Generation

    Hi, I am trying to figure out a way to create a list in one sheet depending on the value of cells in another. I have in "Master List" sheet Column A the names of projects, and in that same sheet in columns I:L I have names of people involved. What I want to do is in another sheet (called...
  5. P

    Macro to save workbook and previous versions

    Hi experts, I was looking for a macro to save a workbook, but also the previous generation. I searched this board and other internet sites but have not found the solution. I know how to save a workbook, but I was looking for the code to find the existence of previous versions ( the -1 and -2...
  6. L

    Complicated Random Loop Macro

    <link rel="File-List" href="file:///C:%5CUsers%5CJonathon%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CJonathon%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping"...

This Week's Hot Topics

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