Hi,
I have this macro to look at a cell and if it finds a certain value, copy that row to another sheet. My formula works if there is only Text in the cell and fails if a formula is creating the text in the cell.
Example Data:
<tbody>
Col A
Col B
Row 1
<tbody>
<tbody>
Project Num...