trying to accomplish something in Excel

Okay, I have a an Excel worksheet that has information that is tracking new business information. Prospects to whom we made proposals and out of those the ones we won (using a column to calculate a Win Ratio, binary).

Now, I would like to pull information (not all, but some) from ONLY the prospects that we won business.

So, simply stated:

?If WinRatio = 1 (in WinRation column) Output to Sheet ("WinReport") information X, Y, Z

Does that make sense at all? I am beginning to use VBA... very basic understanding. I have more experience with SAS programming and HTML programming (definitely not VBA experienced).

Does anyone have any suggestions to accomplish the above?