Start with a WB and one WS with a range of data.
I want to:
Add two new sheets
Check each record on the original sheet and
If Column B in that row = X then
Copy what's in Column A of that row to new Sheet2,
or
If Column B in that row = Y then
Copy what's in Column A of that row to new Sheet 3.