macro Copy and paste from one worksheet to another

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
Mon Feb 25 03:20:24 CST 2008

Hi

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

--
Regards
Roger Govier

"CAM" <alex_martinez@comcast.net> wrote in message
news:urK$NJ1dIHA.2404@TK2MSFTNGP05.phx.gbl...
> 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.
>
>
>
>
>
>
>

CAM
Mon Feb 25 10:41:24 CST 2008

Thanks Roger


"Roger Govier" <roger@technology4unospamdotcodotuk> wrote in message
news:7CAE6990-B8A3-4D2B-B3B9-DA2B9AA39CE1@microsoft.com...
> Hi
>
> Try Advanced Filter to extract the data to other sheets.
> For more information got to
> http://www.contextures.com/xladvfilter01.html#ExtractWs
>
> --
> Regards
> Roger Govier
>
> "CAM" <alex_martinez@comcast.net> wrote in message
> news:urK$NJ1dIHA.2404@TK2MSFTNGP05.phx.gbl...
>> 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.
>>
>>
>>
>>
>>
>>
>>