C
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.
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.