+ Reply to Thread
Results 1 to 4 of 4

Macro: add x value to cellA and prompt to substract x to other cells

  1. #1
    Registered User
    Join Date
    03-01-2016
    Location
    Ottawa
    MS-Off Ver
    365
    Posts
    7

    Question Macro: add x value to cellA and prompt to substract x to other cells

    Hi there, i sure can use your help with this:
    I have a value in cellA1(20)
    I have values is cellB1(5),C1(5)D1(5) and E1(5)
    CellF1 checks for A1-SUM(B1:E1)=0
    I would like users to be able to clic on any B1 to E1 cell (through a button) and add a value (say:add 10 to D1)
    The user then has to be prompted to substract a value of 10(or fractions of it up to 10) to cellB1, C1 or E1 so that my check F1 cell always remains 0. The user could decide to substract 5 from B1 and C1 or any combination that would substract and amount of 10 to the sum(B1:C1)

    What macro can i put in my botton to get that result? Is it possible?

    Thank you so much to this community.
    Last edited by _Mani__; 03-02-2016 at 12:12 PM.

  2. #2
    Forum Contributor amartinez988's Avatar
    Join Date
    05-04-2015
    Location
    Miami
    MS-Off Ver
    Office 2010
    Posts
    183

    Re: Macro: add x value to cellA and prompt to substract x to other cells

    This is not the best option. But at least you have something to work with from what I understood.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-01-2016
    Location
    Ottawa
    MS-Off Ver
    365
    Posts
    7

    Re: Macro: add x value to cellA and prompt to substract x to other cells

    That is fantastic. Thank you very much for sharing your skills.

  4. #4
    Forum Contributor amartinez988's Avatar
    Join Date
    05-04-2015
    Location
    Miami
    MS-Off Ver
    Office 2010
    Posts
    183

    Re: Macro: add x value to cellA and prompt to substract x to other cells

    Thank you Mani.

    Please don't forget to mark the post as SOLVED and add reputation to any member that helped.

    [Cheers]

+ 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. Insert a Row based on cella value
    By nuruedriss in forum Excel General
    Replies: 1
    Last Post: 11-06-2013, 10:38 AM
  2. Average last 3 entries in a row exluding not data cella
    By sling1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-21-2013, 02:24 AM
  3. Valori multipli nella stessa cella
    By pgft in forum Non English Excel
    Replies: 0
    Last Post: 01-15-2013, 07:24 AM
  4. [SOLVED] Input Box Prompt in Multiple Cells - Macro
    By pix in forum Excel General
    Replies: 5
    Last Post: 11-03-2012, 11:34 PM
  5. Replies: 2
    Last Post: 09-28-2012, 05:56 PM
  6. If type X then CellA = 1, if type X2 then CellA = .5 w/ SUM
    By adamsurpren in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-09-2012, 02:35 PM
  7. Replies: 2
    Last Post: 07-29-2009, 08:42 AM
  8. [SOLVED] How do I substract numbers in range like this: Substract(a1..a10)
    By Paulo in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-17-2005, 12:50 AM

Tags for this Thread

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