I have an Automated report...I have A Name in A3 and a decimal time in B3 and that run as long as 300 names. SO list one is in A:B, List 2 is C:D, and List 3 is E:F, Each list has a different set of valid info...
For List one
Column B>11 is valid and should be kept <11 is a trash the for that row A:B should be cleared,
Column D>31is valid and should be kept <31is a trash and for that row C:D should be cleared,
Column f>11 is valid and should be kept <11 is a trash the for that row E:F should be cleared,
I can't delete since I cannot disrupt the other 2 lists. My Columns will be drastically uneven but it is what I need.
(The typical length of the Idol None list with the applied validation is usually about 165 agents, Th Idol Break is usually 70 agents, and Idle_system is usually less than 5 but since there are 300 seats I copied my formula to Row 300)
I have been lurking here and googling the code to do this but only find code that will delete the entire row. Is there a Macro for me?
Thanks in Advance!
Bookmarks