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

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=9378A...121822A3%21326
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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2