+ Reply to Thread
Results 1 to 2 of 2

Reference a cell from an another sheet which is incremental

  1. #1
    Registered User
    Join Date
    09-25-2008
    Location
    US
    Posts
    1

    Reference a cell from an another sheet which is incremental

    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?
    Last edited by pad5; 09-25-2008 at 10:20 AM.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    assuming your data is on sheet2 cols a,b,c
    on summary sheet put in say A1 =TODAY(-1)
    to return Count of Tickets Opened
    use =VLOOKUP($A$1,Sheet2!A:C,2,FALSE)
    and for the other(not resolved)
    =VLOOKUP($A$1,Sheet2!A:C,3,FALSE)
    this will automatically change each day

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA to rename worksheet based on cell reference on another worksheet
    By Sandi99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2008, 01:46 PM
  2. Shorten Code & clean up
    By sammar12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2008, 03:27 PM
  3. Reference cell between worksheets
    By markjoyus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2007, 12:31 PM
  4. Sheet Reference from Cell
    By webstar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-07-2007, 05:59 PM
  5. Replies: 8
    Last Post: 02-03-2007, 01:41 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1