+ Reply to Thread
Results 1 to 7 of 7

Code to calculate values based on %

  1. #1
    Forum Contributor
    Join Date
    05-01-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    822

    Code to calculate values based on %

    Guten Tag,

    I have the following attachment, i need to;

    - For each Row label in Workings ME & MO copy all the data from Original ME & MO and apply the same row label to each line, this then needs to be added to the Output ME & MO sheets but for only the headers on the those sheets.
    - The volume of data will change each month so i think it needs to use a used range formula??
    -In column G of the output tabs, this needs to be a calculation of the cell in F times by the % from the row on the workings tab.

    I've added data to the attachment as what the final data should look like.

    Any help is appreciated

    KA
    Attached Files Attached Files

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Code to calculate values based on %

    File is password protected.

    Alf

  3. #3
    Forum Contributor
    Join Date
    05-01-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    822

    Re: Code to calculate values based on %

    Sorry password is llt

  4. #4
    Forum Contributor
    Join Date
    05-01-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    822

    Re: Code to calculate values based on %

    Bump - No response

  5. #5
    Forum Contributor
    Join Date
    05-01-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    822

    Re: Code to calculate values based on %

    Bump - No Response

  6. #6
    Forum Contributor
    Join Date
    05-01-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    822

    Re: Code to calculate values based on %

    'Bump - No Response'

  7. #7
    Forum Contributor
    Join Date
    05-01-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    822

    Re: Code to calculate values based on %

    Bump - No Repsonse

+ 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