+ Reply to Thread
Results 1 to 1 of 1

Prediction Sheet

  1. #1
    Forum Contributor
    Join Date
    02-21-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    100

    Prediction Sheet

    Attached an example..please open and continue reading.

    PrSales11 shows a list of product, each with their respective sales per month in 2011.
    PrSales12 is another sheet which instead should have "predicted" figures - my idea is to simply take the values from 2011 and add a certain percentage..like for Product 1 in January.. the formula would be PrSales11!E4*1.02 (2%).

    I need to prepare this for future proofing..so that means I cant really put PrSales11 in the formula.
    I will have to get the current sheet name, PrSales12, concatenate and reduce 1 - so thus prSales13 will automatically link to PrSales12, and so on.

    Please help me ot on this!
    thanks

    Should you have any questions, please reply here
    Attached Files Attached Files

+ 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