Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data Consolidation Ideas Welcome (2000)

    Hi all,

    Recently I have become the proud owner of a spreadsheet which lists sales by store by day. The previous user always compared Monday thru Sunday vs Monday thru Sunday. These were designated weeks 1, 2, 3, etc. Sometimes this is known as 4-4-3 in accounting circles. Anyhow, myself and the other inheritors of this sheet (mainly the company I work for), use the dates of the 7th, 14th, 21st, 28th, and last day of month for compiling sales comparisons.

    In the attachment, the first sheet is the data I inherited (I added the columns with the dates, because there were no date references). The second sheet is similar to the format I would like to achieve. I created this sheet by pasting links from the first sheet.

    I would welcome any ideas on how to set up tables to pull this info into the format indicated on the second sheet via either hlookup, vlookup, telepathy, osmosis, subliminal suggestion, or any other way that will work.

    Thanks,
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data Consolidation Ideas Welcome (2000)

    Hi Michael,

    Can you change the layout of the datasheet?

    If so, I'd put all in three columns:

    Store #, Date, Sales

    and use a pivot table to extract the summaries you need.

    BTW: I like the way the sales figures are added to the dates in column R of the franchise sheet <vbg>.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data Consolidation Ideas Welcome (2000)

    HeHe...that is my way of achieving sales increases over last year's sales. Don't tell anyone!

    Thanks for the ideas Jan.

Posting Permissions

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