How can I copy consecutive columns with formulas from sheet2 to a row in sheet1?
M Mark Oct 11, 2006 #1 How can I copy consecutive columns with formulas from sheet2 to a row in sheet1?
M Max Oct 11, 2006 #2 One way .. In Sheet1, Put in A1: =INDEX(Sheet2!$C$5:$IV$5,ROW()) Copy down to A3