Results 1 to 4 of 4

Thread: vba to grab values present currently from a range in another range

  1. #1
    Seeker fortune's Avatar
    Join Date
    Sep 2014
    Location
    MUMBAI
    Posts
    7
    Articles
    0
    Excel Version
    2007

    Post vba to grab values present currently from a range in another range



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Worksheet’s range D7:D133; N7:N133 & O7:O133 gets updated on RTD basis due to feeds in another linked cells of another Worksheet in the same Workbook.

    I need vba to trigger code automatically not manually to ‘grab’ the values present 'currently' from the above range in output range L7:L133; S7:S133 & T7:T133 respectively only if L4=111
    L4 has formula & generates either of 111 or 222 ‘periodically’ during a day. The code should get triggered if L4=111. Nothing should happen if L4<>111 i.e. status quo to be maintained in output range L7:L133; S7:S133 & T7:T133
    I am completely clueless how to even start writing a macro for this.
    Appreciate your help
    Last edited by p45cal; 2019-10-18 at 10:57 PM. Reason: disabled smilies

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,606
    Articles
    0
    Excel Version
    365
    cross posted without links:

    https://www.ozgrid.com/forum/forum/h...-another-range
    https://chandoo.org/forum/threads/vb...r-range.42832/

    fortune/kumarsatish, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184
    Last edited by p45cal; 2019-10-18 at 11:01 PM.

  3. #3
    Seeker fortune's Avatar
    Join Date
    Sep 2014
    Location
    MUMBAI
    Posts
    7
    Articles
    0
    Excel Version
    2007
    Extremely Sorry,
    Not so much aware. Will never do in future.
    Here are the links
    https://www.ozgrid.com/forum/forum/h...-another-range
    https://chandoo.org/forum/threads/vb...r-range.42832/

  4. #4
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    193
    Articles
    0
    Excel Version
    2019
    See my solution at OzGrid

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •