Hi,
Assume the sheet name always be in dd-mmm-yy format. I have define a name
CurrPeriod, you need to define it on your file. Just change Start & End
Date reference in this formula. I also change some Locations for SALES in
multiple sheets to make sure it works :-)
See the attached.
_
Friends help me on this help.
Thanks
N.Sundarvelan
9600160150
-- Forwarded message --
From: Sundarvelan N
Date: Fri, Mar 2, 2012 at 11:52 AM
Subject: $$Excel-Macros$$ Sumproduct accross multiple sheets
To: excel-macros@googlegroups.com
Hi Friends,
Help me in achieving this
Hi Friends,
Help me in achieving this task.
sumproduct across multiple sheets
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Pro