anniehigg
asked on
Excel 2010
In Excel 2010. I have a spread sheet with 2000 rows and 20 columns.
First Column has 20 different partner names the second column has the different clients they are responsible for the third column has a completion date of a project. I would like to be able to create a macro searching by partner and then copy the partners information column 1 2 and 3 into another spreadsheet. Please help...
First Column has 20 different partner names the second column has the different clients they are responsible for the third column has a completion date of a project. I would like to be able to create a macro searching by partner and then copy the partners information column 1 2 and 3 into another spreadsheet. Please help...
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
1. Click on the top left cell on the worksheet with 2000 rows x 20 columns
2. On the Data menu, click on the Filter icon
3. Click on the arrow at the column with partner's names. Choose the desired partner
4. Select the data in the desired columns, then copy and paste them where desired.
The above process is easily automated. Try recording a macro. Post it back in this thread if you need help editing it.
Do you want a single report, with all partner's information shown on the other spreadsheet? If so:
1. Click on the top left cell of the worksheet with 2000 rows x 20 columns
2. On the Data...Sort menu item, choose to sort by the column with partner's name in ascending order
3. Copy the desired columns to the new worksheet
Once again, this process is easily automated with a macro. Try recording one, and post back in this thread if you need help editing it.
I've resisted writing a macro for you because you really haven't defined exactly what you want done. Nor have you posted a sample workbook showing the data layout.