Hi there,
Hope all is well.
I am having trouble figuring this out and would love some assistance as my knowledge is limited.
I have 3 sheets in different docs,
Source doc : Master Sheet
Processing doc: (Results
Search Terms doc: Search list
What i am trying to do is using a value found in the Search list sheet and looking for it in the F column in the Source Doc and if found, bring the whole row into results. The value may repeat throughout the source doc but always in the same column.
Is this something that i can do in VBA so i can just change the value and redo the search?
Help is greatly appreciated.
Karsa
Hope all is well.
I am having trouble figuring this out and would love some assistance as my knowledge is limited.
I have 3 sheets in different docs,
Source doc : Master Sheet
Processing doc: (Results
Search Terms doc: Search list
What i am trying to do is using a value found in the Search list sheet and looking for it in the F column in the Source Doc and if found, bring the whole row into results. The value may repeat throughout the source doc but always in the same column.
Is this something that i can do in VBA so i can just change the value and redo the search?
Help is greatly appreciated.
Karsa