Hi all,
I need some help figuring out how to pick up data from one tab within an excel workbook and transposing some of that data onto another tab.
Basically, I have a list of names, addresses, and monetary values with a drop down list of answers (yes or no). If the answer is yes I want specific data from that row to copy over to another sheet.
I've done my best to illustrate the data below.
Workbook #1
<tbody>
</tbody>
Workbook #2 (Data I want to extract)
<tbody>
</tbody>
I want the second workbook to eliminate any "no" rows and only populate "yes" rows.
How do I do this?
Please help.
I need some help figuring out how to pick up data from one tab within an excel workbook and transposing some of that data onto another tab.
Basically, I have a list of names, addresses, and monetary values with a drop down list of answers (yes or no). If the answer is yes I want specific data from that row to copy over to another sheet.
I've done my best to illustrate the data below.
Workbook #1
Row # | Name | Value of contribution | Is this contribution from a fundraising event? (yes or no) |
1 | Charlie | $200 | Yes |
2 | Sam | $27 | No |
3 | John | $1,000 | No |
4 | Christina | $300 | Yes |
5 | Helen | $100 | No |
<tbody>
</tbody>
Workbook #2 (Data I want to extract)
Row # | Value of contribution | Answer |
1 | $200 | Yes |
4 | $300 | Yes |
<tbody>
</tbody>
I want the second workbook to eliminate any "no" rows and only populate "yes" rows.
How do I do this?
Please help.