+ Reply to Thread
Results 1 to 4 of 4

comparing data from different sheets

  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    Vienna, Austria
    MS-Off Ver
    Excel 2010
    Posts
    32

    comparing data from different sheets

    Hello VBA fans,

    i´ve got differnt Kind of contracts, with different kind of running time.

    In this table i have the year and the costs.

    For example.

    Year/Costs
    2010/10
    2011/600
    2012/1500
    2013/3000
    2014
    2015
    2016
    2018
    2019

    The costs for 2014 - 2019 are not know yet.

    Now i have 6 different kind of contracts. The contracts have several running time´s.


    Now i want to calculate the expecting costs of the contract.


    For each contract with a several running time, i´ve created percentages, in several Sheets.

    So for example, if a contract runs 8 years, after 4 years, 19% of the total costs have allready arisen.

    With this i want to calculate the expected costs.

    This would be then 3000€ (year 4) / 19 (percentage of the total costs in year 4, by a running time of 8 years) * 100.

    Then i have the expected costs.


    It something likes this possible?

    I really have not so much clue how to do that.

    Help, please!


    I put a file in the Appendix.

    Here are further informations.

    greetz benjamin
    Attached Files Attached Files

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: comparing data from different sheets

    Here are two table approaches based on your sample data.

    1) Shows the FIRST YEAR through the CURRENT YEAR (based on today's date)

    2) Shows the FIRST YEAR through the last year listed in the table, even if it's in the future.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-05-2013
    Location
    Vienna, Austria
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: comparing data from different sheets

    Thank´s a lot.

    This is exactly what i was looking for.

    greetz benjamin

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: comparing data from different sheets

    I've marked this thread as SOLVED for you.

    Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Comparing data in 2 sheets
    By JakeMann in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2013, 04:13 AM
  2. Need help in comparing data in 2 sheets
    By giantsquid in forum Excel General
    Replies: 2
    Last Post: 08-26-2008, 03:30 AM
  3. Comparing data of two sheets
    By shenlingstyle in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2005, 01:57 PM
  4. Comparing Data between two sheets
    By AChesley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM
  5. Comparing sheets data
    By Vytautas in forum Excel General
    Replies: 1
    Last Post: 02-15-2005, 06:06 AM

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