ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Get values from 15 sheets in a Wbook (https://www.excelbanter.com/excel-programming/415234-get-values-15-sheets-wbook.html)

Carpe Diem

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






All times are GMT +1. The time now is 07:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com