I am using Excel 2007.
Report has to be populated everyday.
Summary Tab looks like this:
September 22nd 2008 Day
Summary:
Count of Tickets Opened : 2
Count of Tickets Open / Not Resolved :2
Detail :
The day column here has the values for the previousday and now its updated manually.
Detail tab:
data values are populated into the fields in the column ticketsopened and open tickets not resolved columns for the previous day. Once I update this in the Detail tab, I want that data to appear automatically in the summary tab. How to reference the row which is incremented everday to the cells in the Summary tab.
Tickets Opened Open Tickets Not Resolved
Sep 1, 2008 6 1
Sep 2, 2008 2 0
Sep 3, 2008 3 2
Sep 4, 2008 4 0
Sep 5, 2008 2 0
Sep 6, 2008 0 0
Sep 7, 2008 0 0
Sep 8, 2008 3 1
Sep 9, 2008 4 0
Sep 10, 2008 2 1
Sep 11, 2008 3 0
Sep 12, 2008 3 0
Sep 13, 2008 3 0
Sep 14, 2008 1 0
Sep 15, 2008 2 0
Sep 16, 2008 12 4
Sep 17, 2008 5 1
Sep 18, 2008 10 4
Sep 19, 2008 6 2
Sep 20, 2008 0 0
Sep 21, 2008 1 0
Sep 22, 2008 2 2 ------ This should appear in summary tab
Sep 23, 2008
Sep 24, 2008
Sep 25, 2008
Sep 26, 2008
Sep 27, 2008
Sep 28, 2008
Sep 29, 2008
Sep 30, 2008
Total forthemonth: 74 18
Can anybody help me on this?
Bookmarks