I end up getting a circular reference when I try to code this
I have certain reports that recur every 9 days, 16 days, 22 days, 43
days and 76 days respectively. Some of these are workdays and some of
them are calendar days.
I have a weekly report tracker that lets me track which report is due
on a certain week. I want to automate the tracking. I am trying to do
the following
Today's date = getdate() =8/31/09
Report 1 =Getdate()+9 = 9/9/09
on the 9th Day update new Report1 due date = 9/18/09
• Add a column for Status = DONE/Pending
• IF STATUS =DONE
THEN
{
Update the report recurrence to next day based on recurrence
frequency
AND
Append the report name/instance to a named history sheet’s
last empty
cell
}
ELSE
Keep it Active even if the week changes till STATUS =
Done.
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 5,200 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
