Posts by Excelcrazy101

I have a spreadsheet that look like this:
[TABLE="class: grid, width: 500"]

[tr]

[td]

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