Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Other Programming > VBScript
| Search | Today's Posts | Mark Forums Read
VBScript For questions and discussions related to VBScript.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VBScript section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old April 2nd, 2007, 03:11 AM
Authorized User
 
Join Date: Mar 2007
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default summary rpt to help to keep track of action items

Hi,
  I need help on excel.I need to generate a summary report which will help me to keep track on the no. of items that had been closed/pending open for the particular month.The summary report will be generated on a monthly basis & it will be saved in the common folder where all the input files are found.

I need to retrieve data from various workbooks,in order to generate the summary report.Each workbook contains >1 worksheets.Moreover,all the workbooks are stored in a common folder.

The Input file for each workbook,each worksheet will have the following common fields:-
Action_source
Status_Item
Status_Item_dtls
Action_Due_date
Action_Party
Action_Party_Email
Classification_of_Status

How do i merge/link all the data from the various worksheets(from the various workbooks)into 1 sheet? Based on the merged/linked data,how do i generate the summary report?

The summary report generated will gives an overview summary on the following:-
a)No. of outstanding activities with Classification of status=High
b)No. of outstanding activities with Classification of status=Medium
c)No. of outstanding activities with Classification of status=Low

-if Action_Status=Open,need to based on Action_Due_Date to check when the item is due,then, based on the Action_Party_email_address to auto send out the email to the respective Action_party

For example, now is April & the job is ran to generate the summary report in April.
If 'Action_Due_Date'=' May-07', a reminder email will be auto send to the respective 'Action_Party' based on the 'Action_Party_email_address'.

Thanks a million inadvanced.


Reply With Quote


Similar Threads
Thread Thread Starter Forum Replies Last Post
Request action on change and get no action. Help crussell Ajax 0 September 12th, 2007 11:11 AM
populate status values for tracking action items miracles Excel VBA 1 May 16th, 2007 02:47 PM
send email via excel for action items with overdue miracles Excel VBA 0 May 16th, 2007 02:20 AM
validation summary MunishBhatia ASP.NET 2.0 Professional 1 May 11th, 2007 08:00 AM
Summary in footer Blueman137 ASP.NET 1.0 and 1.1 Basics 1 March 30th, 2004 06:48 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.