+ Reply to Thread
Results 1 to 5 of 5

Advanced Loop function help

  1. #1
    Registered User
    Join Date
    05-25-2019
    Location
    Denmark
    MS-Off Ver
    2019
    Posts
    13

    Advanced Loop function help

    Hi experts

    I hope you'll help me with my little issue here,

    I don't know how to start this coding, I need to do for my sensitivity analysis ( følsomheds analyse in Danish)

    The think is a want to change some variables ( 2 to be exact ) when these variables change, the model will calculate a specific number, which I needs to copy and paste in the respective cell. (if necessary see attachment )

    Example : I would need to transfere 1% (b80) in b26 and 5,79% (a81) in b24,( there are current values in these cells )

    then excel will calculate the need value right away, then I need to copy cell j64 and paste it to where b81 is, ( the point where A81 and B80 meets )

    from here loop until Colum A is "" all the time paste a new variable to where the cells meet in the sensitivity analyse. And then jump to next row. when its all done then to reset the values in B26 and B24 as it startet.

    write if im talking nonsense, hope you would help me

    best regals André
    Attached Files Attached Files
    Last edited by Andr095f; 08-16-2019 at 12:24 PM. Reason: Need excel file

  2. #2
    Valued Forum Contributor WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    867

    Re: Advanced Loop function help

    I think you'll need to attached the Excel file here; it's difficult to work with an image.

    WBD
    Excel 2016 on Windows 10, looking for rep!

  3. #3
    Registered User
    Join Date
    05-25-2019
    Location
    Denmark
    MS-Off Ver
    2019
    Posts
    13

    Re: Advanced Loop function help

    Hi WBD

    I've edited the original post, and enclosed the file.

    best regards

  4. #4
    Valued Forum Contributor WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    867

    Re: Advanced Loop function help

    Hey there,

    Give this macro a try and let me know if the numbers look correct!

    Please Login or Register  to view this content.
    WBD

  5. #5
    Registered User
    Join Date
    05-25-2019
    Location
    Denmark
    MS-Off Ver
    2019
    Posts
    13

    Re: Advanced Loop function help

    Hi WBD,

    I simply can't thank you enough. It works perfectly.
    im not that good at coding yet, so I have absolutely no idea what you've just done. I'll look into the code, to see if I can learn and understand.
    once again thank you WBD

    Best regards and have a nice day

+ 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] filter to array not advanced filtering for second loop
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2019, 08:27 AM
  2. Loop a recorded advanced filter macro through all worksheets
    By Bennett_Vic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2018, 10:56 AM
  3. Comparing Similiar DataSets and Calling a Function From a Loop Within a Loop
    By Mark123456789 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2016, 11:27 AM
  4. Find function in nested loop breaking down - not on first time through loop
    By adamstarr12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2014, 04:59 PM
  5. Excel 2007 : Loop Through Advanced Filter Unique Records
    By Wrecking_Crew in forum Excel General
    Replies: 5
    Last Post: 03-21-2010, 01:20 PM
  6. Advanced Loop in macro find maximum value
    By 77anders in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-05-2009, 03:18 PM
  7. advanced filter a range:Advanced Filter function
    By Il Principe in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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