• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

fortune

Member
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 ‘grab’ the values present 'currently' from the above range in output range L7:L133; S7:S133 & T7:T133 respectively if L4=111

I am completely clueless how to even start writing a macro for this.

Appreciate your help
 

Attachments

Marc L

Excel Ninja
As a very beginner starter for the first range (I let you fill the codeline for the other range) :​
Code:
Sub Demo1()
    If [L4].Value2 = 111 Then
        [D7:D133].Copy [L7:L133]
     
    End If
End Sub
Do you like it ? So thanks to click on bottom right Like !​
 

fortune

Member
I need more vba lines like
Code:
Application.CutCopyMode = False
&
rng1.Copy
        Range("L7").PasteSpecial xlPasteValues
etc

though I am new to vba
 
Last edited by a moderator:

Marc L

Excel Ninja
Useless, just directly use a 'Value' property :​
Code:
Sub Demo1()
    If [L4].Value2 = 111 Then
        [L7:L133].Value2 = [D7:D133].Value2
  
    End If
End Sub
You may Like it !​
 

fortune

Member
This has been cross posted by me (not having so much knowledge of cross posting), will never do this in future. Please pardon me.
Here are the links
 
Top