If i have a field named Agents which have values "Transporter","XXX","007" and i want to select each of them, one by one on a particular day of the week lets say Tue. How do macro code it.
Also after selecting the day and a particular agent i have to run a piece of code i.e select Transporter then ..................... select XXX then ...............................