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!!!