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 |
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 |