macro Copy and paste from one worksheet to another

[CAM]

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.

 

[Roger Govier]

Hi

Try Advanced Filter to extract the data to other sheets.
For more information got to
http://www.contextures.com/xladvfilter01.html#ExtractWs

 

[CAM]

Thanks Roger

Hi

Try Advanced Filter to extract the data to other sheets.
For more information got to
http://www.contextures.com/xladvfilter01.html#ExtractWs