|  

» Retrieving a Specific Cell from Multiple Sheets

Problem:

We want to copy the contents of cell A1 from Sheets1-5 into row 2 of the current sheet.
That is, cell C2 of the current sheet is to contain the value stored in cell A1 of Sheet1, cell D2 is to contain the value from Sheet2, and so on.

Solution:

Use the INDIRECT and COLUMN functions as shown in the following formula:
=INDIRECT("Sheet" & COLUMN()-COLUMN($C$2)+1 & "'!$A$1")


Rate This Tip
12 34 5
Rating: 2.33     Views: 14704
Hmm
TheShaolin
This is EXACTLY what I need to figure out, however, the example is pretty vague. Can someone please give a better example of how to use this?
Error in Formula
Syed_Haneef
:confused: The formula sounds good, but it seems there's an error in the syntax.
Click here to post comment
For Registered Users
Name
Comment Title
Comments