generate list

  1. I

    Generate a list of products and locations in a new sheet based on the value from a cell

    Hi, Trying to build an inventory count sheet and I would like to automate the process of adding lines to a sheet when we have 1 product in more than 1 location. Pay attention the the "Bin" column. Here is what my source data looks like: <tbody> Row# Warehouse SKU Description QTY Cost Bin...
  2. S

    How to generate report on rows from multiple worksheets where column has particular text

    HELP!! I've been struggling for a few days with this issue now and although i've come across a few different examples which i think sound similar to what i need my to worksheet to do, given that i'm pretty much a complete novice at VBA, i cant work out how to adapt the examples i've found to...
  3. A

    Generate a list from single cell input

    Hello all, My question is basically how can you generate a list in Excel based on a single cell input? For example, in the single cell the user types 10 then replaces it with 20 and then 30 etc. Is it possible to generate a list like: 10 20 30 etc This could be for any number of inputs, and...
  4. A

    generate ID variable using multiple conditions

    Hi! I'm a beginner at VBA and I need some help. I'm using three data sets with district data. Some district have the same name so I want to apply an ID number instead of using the district names. I have a numeric ID in one of the data sets. I now want to insert that ID in the two data sets...
  5. S

    Return a list(with no spaces) of values based on a condition

    I am trying to generate a list of components that are on at least one part(Par 1, Part 2, Part 3, etc) but I want to exclude the components that are not any part. I generated this list in A11:A15. The formula I used was =IF(SUM(B3:G3)=0,"",A3) -- removed inline image --- That formula gives...
  6. S

    i want to generate 500 random numbers from 100 to 240

    i want to generate 500 random numbers from 100 to 240 and then perform descriptive statistics on it
  7. H

    How to generate sequence based on cell values

    Hi, I have data like <tbody> Citry # of salesman Richardson 5 Irving 3 Plano 2 </tbody> I need to generate unique IDs for the salesman and the table would look like: <tbody> Salesman Unique ID Richardson-1 Richardson-2 Richardson-3 Richardson-4 Richardson-5 Irving-1...
  8. K

    Need formula to generate 5000 6 digit alphanumeric characters

    My town conducts a survey of our residents every year using zoomerang. We want to provide each household with a unique 6-digit alphanumeric character (like B3LM25 or K7ST46) in order to access the survey. I need to provide our printer with a file/list of 5000 different codes so he can print...
  9. P

    Tricky numbering formula

    I have the columns "ID" and "Name". I want to generate an ID for every row but only for each different name so something like this: <table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col...
  10. F

    transform table into list / how to "unpivot" a table

    Hi All, I have a bit of a challenge for least it is for me :-) I have a table of quantity of cars sold by brand (more than two dimensions) that I would like to tranform into a list (5 columns). Please have a look at the data below Your help is HIGHLY always ;)...

Some videos you may like

This Week's Hot Topics