+ Reply to Thread
Results 1 to 3 of 3

Conditional macro

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    canada
    MS-Off Ver
    office 365
    Posts
    20

    Conditional macro

    Hello I am looking for more experts since I did not get an answer yet in other forum but admit it is only 1 day
    Hope I am doing this right
    other post
    https://www.mrexcel.com/board/thread.../#post-6170877

    I am trying to modify a macro
    I want it to maximize so that net income matches spending day to day. the Macro works great
    Where I would like to automate it more is that now it will insert numbers in K even though the funds in T are depleted (red conditioning)
    What I would like it to do is to look at column T and see if there are funds if yes insert calculated number from goalseek macro in K
    If not write in K7 last funds left in this case 7119.64 from t6.
    next 2 lines should be 0
    then funds are OK so 6312 is correct

    Thank-you

  2. #2
    Registered User
    Join Date
    03-11-2014
    Location
    canada
    MS-Off Ver
    office 365
    Posts
    20

    Re: Conditional macro

    Ok thanks to Copilot I got what I was looking for

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,977

    Re: Conditional macro

    Quote Originally Posted by aqus View Post
    Ok thanks to Copilot I got what I was looking for
    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If you solved your own problem, please provide your solution so that somebody seeing this thread in a search for the same problem will see how it was solved.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] Add conditional to VBA macro
    By renguer0 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-21-2020, 03:02 PM
  2. Macro to set up conditional message based on results of conditional formatting
    By paysola in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-04-2016, 12:38 AM
  3. 'Conditional' macro
    By TheaP in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2011, 06:45 AM
  4. Conditional formatting macro (highlight macro)
    By c991257 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2007, 02:46 PM
  5. conditional sum macro
    By kenicholls@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-20-2006, 03:50 PM
  6. [B]Conditional Macro?[/B]
    By Heydilbert in forum Excel General
    Replies: 1
    Last Post: 11-11-2005, 06:10 PM
  7. [SOLVED] Conditional Macro
    By Shelley Shepherd via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-01-2005, 03:06 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