Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2013
    Posts
    2

    Unhappy Unanswered: Moving values of a cell that is dependent on a value

    Hello everyone,

    I have been doing a bit of research on how to do this and it has stumped me. I don't know if I should do macros, or a few complicated calculations to help me.

    I have multiple sheets in this workbook. What I am trying to do is create a model to do a financial forecast. I am asking the user to enter in the number of days it takes to complete a sale (i.e. 90 days). From there, it will look at the headcount that the company has hired. If I have a sheet that has months in my columns to predict a sales forecast, I would want to delay a sale by X days.

    E.G. If the company hires 1 salesperson in January, this person should be expected to get their first deal in April, and so on.

    The issue I have is how to tell Excel to delay a sale based on the input.

    I appreciate any advice.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I'm afraid I don't understand your problem; are you able to clarify?
    George
    Home | Blog

  3. #3
    Join Date
    Sep 2013
    Posts
    2
    Sorry for the confusion. To clarify.

    Assume a cell that asks how many days does it take to make a sale: X

    Assume columns on Sheet B: Jan, Feb, March, April, May, June, July, Aug....
    Rows:
    John
    Bob
    Sally

    Based on the how many days it takes to close a sale, I would want to stagnate the output. Meaning, if X = 45 days, I would need John, who is hired in January to have 0 sales in month Jan, but 2 sales in February, and so on.

    Hope that clarifies. Again, many thanks!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •