fortune
New member
Worksheet’s range D7133; 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
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: