• 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

  • Get Values.xlsx
    16.8 KB · Views: 2
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 !​
 
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:
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 !​
 
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
 
Back
Top