This is to follow the topic: vba - Macro to transfer from one sheet to another
Previously, The macro was transferring specific trips to the Consolidation sheets.
I now need to add an extra validation.
When i double click in column AG if the previous cell starts with "FLEET", it needs to look in column F and find if there is an action on any stops for the TRIP. If there is no stops with actions, it should not transfer the data. But if there is 1 or more actions on any of the TRIP stops, then, it will transfer the full TRIP with all the STOPS in the consolidation sheet.
How can i do that?