How to reference C5, D5, E5 from sheet2 in A1, A2, A3 of sheet1?

Guest · Oct 11, 2006

How can I copy consecutive columns with formulas from sheet2 to a row in
sheet1?

Guest · Oct 11, 2006

One way ..

In Sheet1,

Put in A1:
=INDEX(Sheet2!$C$5:$IV$5,ROW())
Copy down to A3

Excel Moving data to sheet2 from sheet1	0	Nov 2, 2022
specific data	1	Jun 23, 2009
Search Entire Sheet instead of 1?	4	Mar 17, 2010
Copy non merged to merged cells again	1	Feb 6, 2009
data from 1 sheet to the next	6	Apr 17, 2006
SUM of a 3D calculation	6	Sep 24, 2008
RELATIVE REFERENCE WHEN MATCHING 2 PRODUCTS	4	Dec 3, 2008
how do I create a nonadjacent series for autofill to go by?	3	Apr 14, 2009

Ask a Question