Results 1 to 1 of 1

Prediction Sheet

Threaded View

  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

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