+ Reply to Thread
Results 1 to 7 of 7

Copying Formulae

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    897

    Copying Formulae

    The workbook I have attached shows a template ( yellow) that my app copies 12 times onto a worksheet (January shown on this illustration).
    The problem that I have is how to deal with the formulas that I would like to add to the YEAR TO DATE half of the template which would sum up the previous YTD with the current value.
    I have to deal with the fact that December (the first month) is different from all the others as it has nothing to sum to. Secondly that a formula in the template would need to refer to negative column numbers and I don't think Excel allows those.
    Is there a way to use the template which I would prefer or do I have to do something in the completed year sheet?
    John
    Attached Files Attached Files

  2. #2
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    5,920

    Re: Copying Formulae

    your template has no data in it nor any information about what you have or what you want. Please update the attachment with values and some expected results.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    897

    Re: Copying Formulae

    Here is an updated worksheet with some numbers and formulas. I hope this will make more sense.
    John
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    23,777

    Re: Copying Formulae

    Each column (J to S) has its own SUMPRODUCT formula. Here is one of them (it's in K7)

    =SUMPRODUCT(($B$4:D$4="This Month")*($B$5:D$5=K$5)*($B$6:D$6=K$6),$B7:D7)

    then select the datablock (A3 to S19), copy and paste into U1, AO1, etc.
    Attached Files Attached Files
    Glenn



  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    23,777

    Re: Copying Formulae

    Incidentally, this may/may not work with your "app", whatever that might be!! But it certainly works with Copy/Paste....

  6. #6
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    897

    Re: Copying Formulae

    Glenn, any thanks for your help. It does work on my app.
    A propos of your last post, what should I call a stand alone group of procedures which my colleagues can use, without any particular knowledge of Excel to present data from SQL server in a form which meets there needs? Application or app seemed about right to me.
    John

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    23,777

    Re: Copying Formulae

    App seems as good as anything, I guess!!

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ 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