Formual that will move information of 3 cell in a row to a d

September 19, 2014 at 09:03:22
Specs: Windows 7
I HAVE A VERY LARGE WORKSHEET, THAT I NEED TO MAKE REPORTS FROM.
COLUMN A IS LINE #, COLUMN B IS AREA. COLUMN C IS SYSTEM. COLUMN BA IS COMMENTS.
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"
I WILL HAVE TO REPEAT THIS FORULMA FOR A TOTAL OF 29 AREAS. SO, ANY HELP WILL BE GREATLY APRECIATED

message edited by MISSY


See More: Formual that will move information of 3 cell in a row to a d

Report •


#1
September 19, 2014 at 10:58:28
Please refrain from posting in all caps. All caps is the internet equivalent of yelling and nobody likes to be yelled at.

Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 19, 2014 at 11:06:26
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.


Report •
Related Solutions


Ask Question