+ Reply to Thread
Results 1 to 4 of 4

overview of month based on cell value

  1. #1
    Registered User
    Join Date
    10-30-2007
    Posts
    9

    overview of month based on cell value

    Hi
    I don't use excel much and I am sure this is very simple, but not sure how to start.
    I have a spreadsheet of a months invoices across anumber of sites (identified by name and number).
    I want to produce a monthly overview, but the number of rows per store per month varies.
    In the main data sheet there is a row which gives the totals for that store for that month.
    I want to take data from that row and display it in the overview worksheet.

    How best to start?

    The identifying data for each row (about 300 sites) looks like this:
    12 36 Bath Total

    The data I want to access then follows as totals for that site for that month under different headings.
    James

  2. #2
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2016
    Posts
    520
    Hi jash147,

    Can you attach a sample of your file with the expected results?
    Corine

  3. #3
    Registered User
    Join Date
    10-30-2007
    Posts
    9

    sample attached

    Hi
    Sample attached.
    What I'd really like to do (in addition) is to get the spreadsheet to recognie the different categories of waste in Column D.

    James
    Attached Files Attached Files

  4. #4
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2016
    Posts
    520
    Hi
    Sample attached.
    What I'd really like to do (in addition) is to get the spreadsheet to recognie the different categories of waste in Column D.

    James
    Hi James,

    Would you be a little more specific? I really don't understand the task your trying to accomplish.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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