Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert number of rows based on criteria
Hello,
Is there any way to insert a number of rows based on criteria? Sample data: A------------S---T---U-.... Bill---------(_)-(X)-(_) Bob--------(_)-(_)-(_) Joe---------(X)-(X)-(X) Murph .... (Where (_) denotes a blank cell) Desired presentation: Bill---------(_)-(X)-(_) (blank row) Bob--------(_)-(_)-(_) Joe---------(X)-(X)-(X) (blank row) (blank row) (blank row) Murph .... I have a list of names in column A, and a list of criteria names in S1 - Z1. For each name (ie. Bill), criteria is defined as met with any marking in that column (ie. T1 = "X", or "o", or anything nonblank) What I would like to do then is for every row, look at the range S-Z, count the number of nonblank cells, and then insert that number of nonblank rows directly underneath. Then move onto the next name until the list is exhausted. Ideally, though this may be asking too much, each row that is inserted should then have the name of the criteria inserted into AA. So, for instance, in the sample data above, if Bill has an X under column T, and T1 reads "Car", the data should look like this: A------------S---T---U-....AA Bill---------(_)-(X)-(_) ---------------------------....Car Bob.... Any help and a walkthrough of the code would be so much appreciated! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting number of rows based on mutiple criteria | Excel Worksheet Functions | |||
insert rows based on criteria | Excel Discussion (Misc queries) | |||
insert rows based on criteria | Excel Discussion (Misc queries) | |||
Create a Macro to Insert a number into a column based on criteria | Excel Programming | |||
Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) |