+ Reply to Thread
Results 1 to 8 of 8

Changing two cells depending on the input of one.

  1. #1
    Registered User
    Join Date
    01-30-2023
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    4

    Question Changing two cells depending on the input of one.

    I am trying to figure out how to change a cell depending on what is done in another cell. I currently have a cell (V32) that a percentage is entered and it calculates dollar amount (Y30*V32) in another cell (Y32), is there a way that I can either enter the percentage as we do now but have the option to enter a $ amount in Y32 and have it calculate the percentage in V32 (Y32/Y30). So basically I want those cells to be interchangeable for the calculation. I'm thinking I can do it in VBA but I've hit a mental block on how. Thank you for any help.

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Changing two cells depending on the input of one.

    It better attach sample file with desire output.
    How to attach file, refer yellow banner on top of page.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Changing two cells depending on the input of one.

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    01-30-2023
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    4

    Re: Changing two cells depending on the input of one.

    I attached a sample file.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-30-2023
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    4

    Re: Changing two cells depending on the input of one.

    Thank you. That works for part of what I want. I have attached a small example, I hope that makes better sense.

  6. #6
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Changing two cells depending on the input of one.

    Please Login or Register  to view this content.
    Last edited by Croweater; 02-03-2023 at 06:53 AM.

  7. #7
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Changing two cells depending on the input of one.

    Well? Did that do what you wanted?

  8. #8
    Registered User
    Join Date
    01-30-2023
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    4

    Re: Changing two cells depending on the input of one.

    Sorry, I have been out of town on business. Yes, it worked perfectly! Thank you so much!

+ 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] Auto-fill cells depending on input
    By DNA excel function in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-11-2019, 10:56 AM
  2. Copy two cells depending on data being input in another
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2013, 09:48 AM
  3. [SOLVED] Restrict Cells depending on input in another cell
    By Dave350z in forum Excel General
    Replies: 2
    Last Post: 01-28-2013, 11:38 AM
  4. Cells selecting a word input depending on input of another cell
    By ceeje25 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-14-2012, 07:08 AM
  5. [SOLVED] Need help changing a cells value depending on the value on another.
    By randall78 in forum Excel General
    Replies: 9
    Last Post: 06-28-2012, 04:08 AM
  6. [SOLVED] Depending on input, lock or activate cells.
    By jacktiser in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2012, 07:48 AM
  7. Distribute values to cells depending on the input value
    By msal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2009, 07:35 PM

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