Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recurring report recurrence updates and history tracker
Hi,
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 it further. I am trying to do the following • 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. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I create a recurrence formula in Excel e.g. A(N+1)=A(N)+2 | New Users to Excel | |||
looking for a function for recurrence of a number in excell | Excel Worksheet Functions | |||
recurrence | Excel Worksheet Functions | |||
run a history report in the background | Excel Worksheet Functions | |||
Change Tracker History Log | Excel Programming |