Hello,

I am using Excel 2003 within the workbook I have a worksheet call "Detail"
I want to copy and paste selected data to another worksheet called "Exhibit
A" or "Exhibit B" based on data from a cell.

            Name             Type         Exhibit

row 1      John Doe       Cash        Exhibit A
row 2      John Smith     Credit      Exhibit B
row 3      Jane Doe       Cash        Exhibit A

Data from row1 and row 3 will go to worksheet called "Exhibit A" starting
from cell A4 and so on.
Data from row 2 will go to worksheet called "Exhibit B" starting from cell
A4 and so on.

Now here is the catch I may have thousands of  rows in the "Detail"
worksheet.  This is a monthly report meaning there might be 6,000 records
for one month or perhaps 10,000 records for another month.  Rows will vary.
I just need an expert who can help me make a macro to copy  data based on
cell from a row and paste it into the proper worksheet.  Any tips or website
to visit, please let me know.  Thank you in advance.