In Excel, I am trying to copy data from sheet1 to sheet2. The specific row number of data I need to copy is defined in a cell on sheet2 as a value. The formula should reference the value of this cell to know which row of data to copy.
In the cell I am trying to copy data to I have tried the formula,
=concatenate(“Sheet1!”,”E”,VALUE($B$18))
Which returns Sheet1!E46, but I need it to return the data that is actually in that cell on the other sheet.
New contributor
batteryanalysis is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.