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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to reference C5, D5, E5 from sheet2 in A1, A2, A3 of sheet1? (https://www.excelbanter.com/excel-worksheet-functions/113817-how-reference-c5-d5-e5-sheet2-a1-a2-a3-sheet1.html)

Mark

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

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

Max

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

One way ..

In Sheet1,

Put in A1:
=INDEX(Sheet2!$C$5:$IV$5,ROW())
Copy down to A3
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mark" wrote:
How can I copy consecutive columns with formulas from sheet2 to a row in
sheet1?

All times are GMT +1. The time now is 05:32 PM.