View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carpe Diem Carpe Diem is offline
external usenet poster
 
Posts: 28
Default Get values from 15 sheets in a Wbook

Hi,

I have a file with 15 sheets, and I need to get 10 type of values
each
month accordin one or two conditions. So I use sumproduct to get
thios
values for each sheet to put in another sheet but the problem is that
I have to do 15 sumproduct in the same cell and the formula on one
cell is limited.


Have another to do it ? for example using names for ecah sheet ???


Thanks in advance


Ricardo