Multiple worksheet summary

[PamaLove8628]

I am working on a document I need help indexing. I have 44 worksheet
in the same document with detailed information pertaining to eac
individual case. I want certain bits of these details readily availabl
in one worksheet, like an index or a summary. All the information I'v
found so far was pertaining to mathematical functions using the cells o
other worksheets, but I just want to display the data in specific cell
without scrolling through and individually linking each individual cel
to the corresponding worksheet cell. I'm attaching a similar situation
I know nothing about VB and very minimal about macros or pivot table
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
+-------------------------------------------------------------------

 

[Claus Busch]

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.

 

[Claus Busch]

Hi,

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.
+-------------------------------------------------------------------+
|Filename: Sample.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=892|
+-------------------------------------------------------------------+

if you could change your sheet names to "Patient 1", "Patient 2" you
could use in sheet Index A2:
=IFERROR(VLOOKUP(A$1,INDIRECT("'Patient "&ROW(A1)&"'!A1:B1000"),2,0),"")
and copy to the right and down.


Regards
Claus B.

 

[PamaLove8628]

I did this and the cells remain empty - it returns no informatio
whatsoever. Could you please explain the values so I can repair th
formula?

Hi,

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

+-------------------------------------------------------------------+-

if you could change your sheet names to "Patient 1", "Patient 2" you
could use in sheet Index A2:
=IFERROR(VLOOKUP(A$1,INDIRECT("'Patien
"&ROW(A1)&"'!A1:B1000"),2,0),"")
and copy to the right and down.


Regards
Claus B.

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Claus Busch]

Hi,

Am Wed, 24 Jul 2013 14:19:48 +0100 schrieb PamaLove8628:

I did this and the cells remain empty - it returns no information
whatsoever. Could you please explain the values so I can repair the
formula?

please have a look:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbooks "Sample" and "Sample2"
Workbook "Sample" has sheet names like "Patient 1" etc.
Workbook "Sample2" works with VBA and it doesn't matter what the sheet
names are like.
In SkyDrive macros are disabled. So you have to rightclick and download
the workbook.


Regards
Claus B.