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. ...
I mucked around with it and it now works! I needed to add an apostrophe to the spreadsheet name:
=INDIRECT("'[Data]Sheet1'!$" & A1 & ":$" & A1)
My goodness, thank you so much! You have cut my work load in half!
