tfowlerusa
New Member
- Joined
- Mar 28, 2017
- Messages
- 13
I have a sheet where I am trying to pull only the cell where the value is greater the 3 and put them in column H & I within the same sheet. I have a list in Table 1 where if "F" is > the 3 with conditional formatting on. Is there a way to pull only data from Table 1 with Qty > then 3 and match it like in Table 2 columns "H" & "I"? ( I manually created the columns in Table 2 ) Thank you.
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
Table 1
E | F | ||||||||||||||||||||||
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<tbody> </tbody> | <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<tbody> </tbody> |
<tbody>
</tbody>
Table 2
H | I | ||||||||
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<tbody> </tbody> | <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<tbody> </tbody> |
<tbody>
</tbody>