I have a spreadsheet that look like this:
[TABLE="class: grid, width: 500"]
Facility
[/td][td]analyte
[/td][td]sample ID
[/td][td]date
[/td][td]results
[/td][td]units
[/td][td]OEL
[/td][td]Percent OEL
[/td][/tr][tr][td]wherever, USA
[/td][td]acetone
[/td][td]ABC-123
[/td][td]2/2/2017
[/td][td]275
[/td][td]ppm
[/td][td]250
[/td][td]110%
[/td][/tr][tr][td]wherever, USA
[/td][td]acetone
[/td][td]ABC-123
[/td][td]2/2/2017
[/td][td]87
[/td][td]ppm
[/td][td]250
[/td][td]35%
[/td][/tr]
[/TABLE]
I need to copy the whole column to a different existing sheet if the Percent OEL is >100%
What is the best way to do that?
I am not very good at coding or macros, so please be thorough and patient!
Thanks in advance for any help!!
Thanks!!!