I have a large spreadsheet with about 25 columns, I want to pull information
from this sheet to individual sheets within the same workbook. IE I have a
sheet labelled sales and I want to pull all the sales to a separate sheet for
sales persson a & b but not c. Lets say all the sales (a,b,c) are in column
b.

Trinab