ExcelBanter - Copying data from one worksheet to another from rows to columns

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

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

- - Copying data from one worksheet to another from rows to columns (https://www.excelbanter.com/excel-worksheet-functions/125759-copying-data-one-worksheet-another-rows-columns.html)

ked

Copying data from one worksheet to another from rows to columns

I am copying data from worksheet RN to worksheet ALL. The problem I'm trying
to copy the information from a row into a column - I'm using the formula
=RN!B6, in each cell. the problem is I can't get the formula to hold the row
# and change only the column as I go down. Is there a way to do this without
having to enter it all by hand?

All times are GMT +1. The time now is 07:17 PM.