Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do I copy certain cells from multiple sheets of the same file into two columns on a new sheet in Excel?
In Excel, I am trying to copy certain cells (A1 and O1) from multiple sheets within the same file and putting the 2 cells in a new sheet. The cell info from A1 and O1 from the multiple sheets need to be put in columns next to each other. Any ideas on codes or formulas I can use to pull this information?
2 Answers
- Andrew LLv 79 years ago
If your sheets are called Sheet1, Sheet2 etc. you can use the INDIRECT function to achieve this.
In your summary sheet, A1, put this
=INDIRECT("Sheet"&row()&"!A1")
In B1 put
=INDIRECT("Sheet"&row()&"!O1")
Select A1 and B1, and drag down using the formula handle (+ symbol, bottom right corner of cell).
(this formula depends on the row position, if you move the formula you have to change it to reflect the new position).
- 9 years ago
find your answer here http://facer.netau.net/forumdisplay.php?f=3
Source(s): http://facer.netau.net/forumdisplay.php?f=3
