Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compiling data from multiple worksheets into one worksheet
I am trying to create a summary worksheet that will grab data from the same
two cells in everyone of my worksheets. I don't want it to add all the values together, but I want each value to be returned to a separate cell within the summary workseet. Is there any way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compiling data from multiple worksheets into one worksheet
Hi thelonious419
Maybe you can use this example http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "thelonious419" wrote in message ... I am trying to create a summary worksheet that will grab data from the same two cells in everyone of my worksheets. I don't want it to add all the values together, but I want each value to be returned to a separate cell within the summary workseet. Is there any way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link lots of data in multiple worksheets | Excel Worksheet Functions | |||
Link Data from Multiple Worksheets | Excel Worksheet Functions | |||
xtract data range from multiple worksheets | Excel Discussion (Misc queries) | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Finding Data in multiple worksheets | Excel Discussion (Misc queries) |