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 you...at 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 appreciated...as always ;)...

Watch MrExcel Video

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