• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Update SUM formula - with a newly created sheet based on WS index or date.

D

Dhamo

New Member
Hi,


I am supposed to create a new worksheet with today's date(Format: MMM-DD-YYYY). After I create I need to update the summary sheet with this formula(=Sum(DEC-26-2012!A1:A5). Any possibilities to change this formula automatically after creating the sheet.


Curious to know how to do based on date and index value of the sheet.!


Thanks
 
Hi Dhamo,


Please see this sheet:


http://dl.dropbox.com/u/60644346/Indirect%20Sheet%20Name.xlsx


Regards,
 
You must log in or register to reply here.
Back
Top