|We need some clarification. You said:|
I need a forumla that will move, to another worksheet, the line #, and system. based on if BA contains "PWHT" and also if b contains "01X0"
Do you mean move or do you mean copy?
We may be able to accomplish copying with a formula, but moving will require a macro.
You also said:
I will have to repeat this formula for a total of 29 areas.
Could you explain what you mean by that?
Please keep in mind that we can't see your spreadsheet from where we're sitting, so the more detail you provide, the easier it will be for us to help you.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.