View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tzveti
 
Posts: n/a
Default question about many sheets in one warkbook


Hi,
I want to thank to everyone who help me for my last difficulty with
excel.
My question is:How can I sum numbers from different sheets with one
address. But these sheets must be selected by the name in one cell,
again with address, which is the same for all sheets. For example: I
have 50 sheets in one warkbook, but only in 5 there is a name KAI, in
cell with adress(a5). I want to sum the numbers from this sheets with
name KAI from the address h31.
Thank you in advance.
Excuse me for my bad english ;)


--
tzveti
------------------------------------------------------------------------
tzveti's Profile: http://www.excelforum.com/member.php...o&userid=32566
View this thread: http://www.excelforum.com/showthread...hreadid=546772