I hope I explain this so everyone understands. I have included a screenshot for some clarification. For every instance of "held" in column F, i want the corresponding cells A-E to be copied to another sheet.
https://www.dropbox.com/s/k7mbt18510m766u/inside sales 2.JPG?dl=0
TIA
https://www.dropbox.com/s/k7mbt18510m766u/inside sales 2.JPG?dl=0
TIA