Formulas and Functions copy an array from sheet 1 to sheet2.
I want to type a number into a cell on sheet 2. Then lookup that number on sheet 1 (column A). Then select the horizontal array for this number columns B:F. Insert the selected array into sheet 2 in columns C:G. The typed number varies from 1 to 146.
I want to type a number into a cell on sheet 2. Then lookup that number on sheet 1 (column A). Then select the horizontal array for this number columns B:F. Insert the selected array into sheet 2 in columns C:G. The typed number varies from 1 to 146. Read More
