I have two worksheets within the same workbook. One worksheet is just a summary of the other, and is used exclusively for printing. The other worksheet contains multiple formulas, but with a total, which is registered in column A in Worksheet 1.
In worksheet 2, this data may appear in column 1, column 10, or column 20. How can If I do an equal for the first row at the top of each column, how can I make it increase the row number going down the column, so that the correct data is copied?