Hi,
I hope this is an easy one. I have a worksheet with 4 columns of info in it. Looks like this
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I manually search by the number in column A and see if there is a date in column B, if yes, then I look at the data in column C and D to see whats there. The search set I use is variable and comes from a different program. I would like to be able to use a tab in the workbook to paste my search set in column a, run a search and then report any numbers with data in column B, as well as the data included in the other two columns to another tab or set of columns in the workbook.
So the logic seems pretty straight forward : I manually fill a search set, run search, IF Data in Column B for any of the numbers searched Then Report row to ? (I dont care where just so I can find it)
Any help would be appreciated. I'm still a novice and this one is over my head.
Thanks
SHmim
I hope this is an easy one. I have a worksheet with 4 columns of info in it. Looks like this
1089 | NA | ||
1090 | 6/19/12 | NA | Already done |
1091 | 6/8/12 | NA | |
1092 | 4/26/12 | NA | |
1093 | 4/4/12 | NA | |
1094 | 4/26/12 | NA | |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I manually search by the number in column A and see if there is a date in column B, if yes, then I look at the data in column C and D to see whats there. The search set I use is variable and comes from a different program. I would like to be able to use a tab in the workbook to paste my search set in column a, run a search and then report any numbers with data in column B, as well as the data included in the other two columns to another tab or set of columns in the workbook.
So the logic seems pretty straight forward : I manually fill a search set, run search, IF Data in Column B for any of the numbers searched Then Report row to ? (I dont care where just so I can find it)
Any help would be appreciated. I'm still a novice and this one is over my head.
Thanks
SHmim