Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find values from cells in multiple sheets
I have a workbook containing several sheets , all of which use identical
formats - 12 sheets, one for each month of the year. I want a summary sheet with the values of the same cell address in each sheet For example, Summary!A5 = Sheet1!A10 A6 = Sheet2!A10 and so on Is there an inbuilt Excel function or simple way to do this. -- AS |
#2
|
|||
|
|||
One way:
Enter in A5: =INDIRECT("Sheet"&ROW(A1)&"!A10") And copy down as needed. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "asubramaniam" wrote in message ... I have a workbook containing several sheets , all of which use identical formats - 12 sheets, one for each month of the year. I want a summary sheet with the values of the same cell address in each sheet For example, Summary!A5 = Sheet1!A10 A6 = Sheet2!A10 and so on Is there an inbuilt Excel function or simple way to do this. -- AS |
#3
|
|||
|
|||
In Summary!A5 enter =INDIRECT("Sheet"&ROW(A1)&"!A10") to get value from
Sheet1!A10 Copy to A6 from Sheet2, etc best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "asubramaniam" wrote in message ... I have a workbook containing several sheets , all of which use identical formats - 12 sheets, one for each month of the year. I want a summary sheet with the values of the same cell address in each sheet For example, Summary!A5 = Sheet1!A10 A6 = Sheet2!A10 and so on Is there an inbuilt Excel function or simple way to do this. -- AS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
Weighted Avg - using values from multiple sheets | Excel Worksheet Functions | |||
How to find the minimum value in a database with multiple values . | Excel Discussion (Misc queries) | |||
Multiple X-Axis Values | Charts and Charting in Excel | |||
count cells over multiple sheets | Excel Worksheet Functions |