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

fortune

New member
Joined
Sep 26, 2014
Messages
7
Reaction score
0
Points
0
Location
MUMBAI
Excel Version(s)
2007
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 a moderator:
Last edited:
Back
Top