Having trouble working out how I copy and paste the formula to the rest of the rows in a column.
Column A has...
=Data!C18 (row 1)
=Data!C27 (row 2)
=Data!C36 (row 3)
What is an easy way to fill in the rest of the rows of the column without doing =, then go back to the data sheet and selecting...