Excel Champs,
Looking for creative solves for the below problem. I have a project sheet that looks something likes below in a table. I need a button function that can transfer in a separate sheet all the values in that row for that project transposed in a column.
Master file (Sheet 1)
<tbody>
</tbody>
Sheet 2:
<tbody>
</tbody>
Example: If Project is selected in sheet 2 cell A1, the outcome below should be in a separate sheet:
<tbody>
</tbody>
Any help on this, would greatly appreciate it.
Thank you.
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>
Looking for creative solves for the below problem. I have a project sheet that looks something likes below in a table. I need a button function that can transfer in a separate sheet all the values in that row for that project transposed in a column.
Master file (Sheet 1)
A | B | C | D | E | |
1 | Project | Owner | Status | Risk | Team |
2 | A | Jack | On Track | None | None |
3 | B | Mary | RIsk | Short on funding | Joe, Mary, Mira |
4 | C | Vick | Need Help | Need more resources | Kayle, Mike |
<tbody>
</tbody>
Sheet 2:
A | B | |
1 | Project Name | Button/Function (Create Summary) |
<tbody>
</tbody>
Example: If Project is selected in sheet 2 cell A1, the outcome below should be in a separate sheet:
Project | Project A |
Owner | Jack |
Status | On Track |
Risk | None |
Team | None |
<tbody>
</tbody>
Any help on this, would greatly appreciate it.
Thank you.
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
A | B | |
1 | Project Name | Button/Function (Create Summary) |
<tbody>
</tbody>