Dear All,
This below is one of the TOUGHEST one to solve, appreciate your review and
feedback.
A format needs to be prepared wherein for a task to accomplish you have
following status:
1) Done
: Completed.
2) Pending
: Not done within the given time frame.
3) Under process :
Is working presently
4) SAR (Subsequent Action Required) :
User
checks for formalities if doesn’t meet the
Sends back and do this loop unless and until the
Transaction is closed finally
If you understand above, please you may proceed to make such a format which
generates :
1) Tracking Sheet to show the status.
2) Pending Sheet shows all pending ones.
3) Done Sheet which shows all the completed one.
4) Under process shows all the Under Process.
Regards
Priya Jose
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
