Excel: Copy-Paste Data

I am a novice and hope somebody is able to help, I searched the forum with no luck. What I would like to do is copy the data in each corresponding row only if there is a "W" or a "P" in column AU3:AU12. So if AU12 has a "W" then all the data in row AW12:BI12 is copied to M3:Y3 same sheet, and if AU3 has a "P" then all the data in row AW3:BI3 is copied to AA3:AM3 same sheet. The next day whatever place (AU3:AU12) the "W" and "P" are, the correpsoning rows will be copied one row down as M4:Y4 for "W" criteria, and one row down as AA4:AM4 for the "P" criteria. Thanks. GL

This question generated 27 answers. To proceed to the answers, click here.

This thread is current as of October 13, 2013.

For more resources for Microsoft Excel