Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    May 2003
    Location
    Mid-Cheshire, England
    Posts
    275
    Thanks
    1
    Thanked 3 Times in 3 Posts

    Is it possible? (MS Excel 2000 SP3)

    I want to have an arrangement so that on first entering data into a worksheet cell A1 is available to the user to make a numerical entry. Thereafter when a calculation has been performed elsewhere on the sheet the result of that calculation appears in cell A1 and the separate calculation of which the contents of cell A1 are a parameter are revised.

    Is this possible? And if so I would very much like to know how to arrange it.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Is it possible? (MS Excel 2000 SP3)

    You could use the Worksheet_Change event to monitor whether specific cells have changed, and if so, populate A1 with a value or a formula. I realize this is rather vague, but so is your question. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    3 Star Lounger
    Join Date
    May 2003
    Location
    Mid-Cheshire, England
    Posts
    275
    Thanks
    1
    Thanked 3 Times in 3 Posts

    Re: Is it possible? (MS Excel 2000 SP3)

    Thank you for your response. I understand the principle of what you suggest but I haven't any idea how to implement it. Can you assist me please?

    Please see the attachment. On opening a new worksheet amongst others cell D5 is blank. The user types a rental in that cell as well as typing appropriate data in other cells. The formula in cell E21 returns the result of the basic calculation. The next step is to enter a target rent in cell E25 that displays a target rental in cell E27. I want that target rental to change the rental in cell D5 each and every time the the target rental is recalculated.

    I hope this is less vague!
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Is it possible? (MS Excel 2000 SP3)

    What exactly do you want to match? E21 and E25? Or E23 and E25? Or some other cells?

  5. #5
    3 Star Lounger
    Join Date
    May 2003
    Location
    Mid-Cheshire, England
    Posts
    275
    Thanks
    1
    Thanked 3 Times in 3 Posts

    Re: Is it possible? (MS Excel 2000 SP3)

    I want D5 to match E27.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Is it possible? (MS Excel 2000 SP3)

    <img src=/S/groan.gif border=0 alt=groan width=16 height=15>

    Try this.
    Attached Files Attached Files

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Is it possible? (MS Excel 2000 SP3)

    Or even simpler...
    Attached Files Attached Files

  8. #8
    3 Star Lounger
    Join Date
    May 2003
    Location
    Mid-Cheshire, England
    Posts
    275
    Thanks
    1
    Thanked 3 Times in 3 Posts

    Re: Is it possible? (MS Excel 2000 SP3)

    Beautiful <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> and thank you.

    Twice over <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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