+ Reply to Thread
Results 1 to 2 of 2

Adjust one cell in a set of percents that add to 100% and other cells adjust automatically

  1. #1
    Registered User
    Join Date
    06-29-2017
    Location
    USA
    MS-Off Ver
    Office 2016
    Posts
    76

    Adjust one cell in a set of percents that add to 100% and other cells adjust automatically

    Helllo!

    Please see the attached spreadsheet, it describes what I'm talking about better than I can here.

    I have a 5 cells that are percents that add up to 100%. I want to be able to adjust one cell and have the other adjust so that the total is 100%. But what I can't figure out is: I want there to be logic of which cell adjusts and by how much. Each cell will have their own logic for how the % is distributed to the other 5 cells. Is this possible somehow?

    Ideally (end goal) I would have sliders for each cell that automatically adjusts all other cells based on that logic so that the total is always equal to 100%.

    Thanks!
    Attached Files Attached Files
    Last edited by Katie620; 02-04-2019 at 07:51 AM.

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Adjust one cell in a set of percents that add to 100% and other cells adjust automatic

    With a little VBA in the worksheet module:

    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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] How to adjust row height of row so tall the point to grab to adjust auto falls below
    By juntjoo in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-22-2016, 02:07 PM
  2. Automatically adjust row height in merged cells (code needs tweaking)
    By harryco79 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2015, 07:31 AM
  3. [SOLVED] Auto Adjust Stacked Column Need to Adjust Legend
    By tbren in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-29-2013, 01:56 PM
  4. Automatically adjust row height in merged cell
    By jennifersmigla in forum Excel General
    Replies: 0
    Last Post: 03-16-2013, 01:15 PM
  5. Adjust rent increase through calendar, can excel adjust numbers itself?
    By divashenko@yahoo.com in forum Excel General
    Replies: 1
    Last Post: 01-16-2009, 05:31 PM
  6. Adjust the size of cells automatically
    By Dajana in forum Excel General
    Replies: 1
    Last Post: 09-06-2005, 10:05 AM
  7. Text Wrap, Cell Height Does NOT Automatically Adjust
    By Al Franz in forum Excel General
    Replies: 1
    Last Post: 01-24-2005, 10:07 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