JulieAB
09-19-2005, 11:23 AM
I desperately need help creating a macro that will take information from one Excel spreadsheet and do the following:
1. I want to be able to "look" for any lines that contain a specific word (such as "worn"), but that word will change frequently, so, if possible a field where a new word can be inserted each time.
2. If a line is found containing that specific word, then the entire line be copied into another worksheet automatically.
Any help you can give would be greatly appreciated !!!
Thank you!
If you'd like a sample, I can send that directly - but I would prefer not to put the link onto a public message board due to some confidentiality issues.
1. I want to be able to "look" for any lines that contain a specific word (such as "worn"), but that word will change frequently, so, if possible a field where a new word can be inserted each time.
2. If a line is found containing that specific word, then the entire line be copied into another worksheet automatically.
Any help you can give would be greatly appreciated !!!
Thank you!
If you'd like a sample, I can send that directly - but I would prefer not to put the link onto a public message board due to some confidentiality issues.