Results 1 to 2 of 2

Thread: Format problem

  1. #1
    Join Date
    Mar 2005
    Posts
    55

    Unanswered: Format problem

    Please refer to attachment. I currently have a realtively large data set approximately 500 line items. In the format as shown in the sheet titled 'Current format' and i need it in the format as per sheet 'desired forma'. Is there a way to automatically change the format, rather than individually rearranging the fields
    Attached Files Attached Files

  2. #2
    Join Date
    Dec 2003
    Location
    Ottawa, Canada
    Posts
    72

    Solution using Drop-Down Lists and SUMPRODUCT

    Hi

    See the attached workbook. A simple solution using drop-down lists and the SUMPRODUCT function.

    Hope you like it

    To learn more bout drop-down lists and SUMPRODUCT visit my website at:

    http://www.excel-vba.com
    Attached Files Attached Files
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick
    www.excel-examples.com

Posting Permissions

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