This request has already been started. Please would the same person kindly continue to work on it. Thank you.
here are my two problems, both involving a VBA macro that I need to repeat until the end of the data:
1) insert x (cell-defined) blank rows, copying data from above row down (have managed this part), then jumping down to cell Ax-1 (where the data left off), and repeating the process: inserting x blank rows, and copying data from above row.
2) insert multiple values that correspond to a lookup item down one column, repeating if a condition is met
Solved by X. H. in 28 mins