PDA

View Full Version : short scrip to do a check



wolf.stalker
11-14-2011, 08:35 PM
hey all, would like some input on how to design a script. :hi:

(will include my report)

the goal of the script will be to identify each site where
1) column B = "U" and where column D does NOT have the fewest hours ( if a site has 3 rows, then the row with U must be fewest).
2) if column D does NOT have the fewest hours for all rows for that site, then all rows of that site need to go on another sheet.
3) if column D does have the fewest hours, then no action needs to be taken OR all rows for that site can be deleteled.

any one able to provide some direction on this?