Forum Discussion
Formula that copys data based on a random row number
Hi Excel Community, I am wondering if it is possible to have a formula (or set of formulas), that will copy data from a row in another spreadsheet simply by typing that row number into a cell. ...
You could use the INDIRECT function but the other workbook must be open!
Let's say you enter the row number in A1, the formula would then look like this:
=INDIRECT("[Data]Sheet1!$" & A1 & ":$" & A1)
Thank you so much however that formula is giving me the #REF! error...