The workbook I'm creating consists of four worksheets: a static list of terms, broken into groups with empty rows between groups; an input sheet; an output sheet combining groups with text input in sheet 2; and a final static output sheet. Formulas read the data from the groups into the input page, then read from that to the output page. I'm trying to figure out how to make my VBA code: 1) copy only the rows where the formulas return a value in sheet 3 and append to the end of sheet 4; and 2)update the number in a cell which tells the formulas in sheet 2 where the start of the next group is.
Sorry if this is vague, I can put together an example file if necessary.
Sorry if this is vague, I can put together an example file if necessary.
