LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 37
Default return same cell value from numerous sheets

I have 30 sheets. I would like to have a summary sheet that will return the
same cell value from each sheet. For instance, I want my summary sheet to
return the values for:

Sheet 1 C2
Sheet 2 C2
Sheet 3 C2

Thanks!
--
Laurie
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to lookup in numerous different sheets Zak Excel Discussion (Misc queries) 6 January 11th 08 12:24 PM
Comparing numerous sheets Zak Excel Discussion (Misc queries) 5 January 10th 08 09:57 PM
Return a blank cell instead of a zero value for two linked sheets. Matt Excel Discussion (Misc queries) 1 February 4th 07 02:37 AM
search multiple sheets for specific date, return data in cell to r NonIllegitimiCarborundum Excel Discussion (Misc queries) 0 April 28th 06 09:02 PM
Return all sheets to cell A1 glenlee Excel Discussion (Misc queries) 4 September 25th 05 01:03 PM


All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"