generate list

Dear Guys, I am just start learning VBA from the beginner and really frustrating on convert excel formulas to VBA. I would like to Generate a "Consolidated Balance Sheet" table (right side) from the raw Balance Sheet data on the left via VBA. Is it possible to do that? I also attached the...

I’m part of an employee engagement team. We are sending out games/activities through email monthly and keeping track of participation. Each month the employee participates in, gets a “1”. If they don’t participate, the field is blank (or I can change to 0). At the end of the quarter, the number...

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

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

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

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

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

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

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

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

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

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 ;)...