View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Multiple worksheet summary

Am Mon, 22 Jul 2013 04:04:33 +0100 schrieb PamaLove8628:

I am working on a document I need help indexing. I have 44 worksheets
in the same document with detailed information pertaining to each
individual case. I want certain bits of these details readily available
in one worksheet, like an index or a summary. All the information I've
found so far was pertaining to mathematical functions using the cells of
other worksheets, but I just want to display the data in specific cells
without scrolling through and individually linking each individual cell
to the corresponding worksheet cell. I'm attaching a similar situation.
I know nothing about VB and very minimal about macros or pivot tables
or any of the things I've found thus far. :( Thanks in advance!

+-------------------------------------------------------------------+
|Filename: Sample.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=892|
+-------------------------------------------------------------------+



Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2