+ Reply to Thread
Results 1 to 3 of 3

Need to assign dynamic row in macro

  1. #1
    Registered User
    Join Date
    11-13-2018
    Location
    Tampa, Florida
    MS-Off Ver
    2016
    Posts
    2

    Question Need to assign dynamic row in macro

    Good afternoon (or morning on the westcoast)!

    So, I am working on a spreadsheet for a client that requires formula input which needs to be placed for the row to calculate properly. Heres my example

    =IF(AH24=>24, 6000.00, 219.40*AH24)

    Essentially heres the breakdown:

    AH24 represents a sum of units for a calendar month. 24 units is a threshold that must be met for condition 1 to be true. 23 units or less will be calculated with elseif statement.


    I am attempting to set up multiple macros at different rates that will allow the client to insert row with specific financial conditions, and the problem is I need to figure out how I can make a row variable that will assign itself to a static column.
    The only static that I have is the column, AJ on this sheet.


    Any help would be greatly appreciated!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,948

    Re: Need to assign dynamic row in macro

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and click "manage attachments" to open the upload window.


    To add a file to a post

  3. #3
    Registered User
    Join Date
    11-13-2018
    Location
    Tampa, Florida
    MS-Off Ver
    2016
    Posts
    2

    Re: Need to assign dynamic row in macro

    Here is the example
    Attached Files Attached Files

+ 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] Assign Click Action to Dynamic Button on Userform
    By me_bee in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-17-2018, 05:51 PM
  2. [SOLVED] Assign macro to a dynamic button using vba
    By hanif in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-11-2016, 04:26 AM
  3. Assign dynamic value to checkboxes
    By MOHAMMESALMAN in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2015, 04:42 AM
  4. Assign dynamic value to checkboxes
    By MOHAMMESALMAN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2015, 04:00 AM
  5. How to... Assign a dynamic range as a table
    By Inti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2014, 05:17 AM
  6. [SOLVED] Dynamic Assign of Variable
    By msherifam01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2013, 07:06 AM
  7. Assign active cell in macro with Dynamic Cell choice
    By scaffdog845 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-29-2009, 03:58 PM

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