JainAbraham
Board Regular
- Joined
- Feb 19, 2014
- Messages
- 92
Hi All,
I am asked to make a macro for the following:
i have two sheets where in one sheet say Home.xls has few columns in it like
<TBODY>
</TBODY>
and the othe sheet say Away.xlsx has simillar columns with only ID similar to the one in the Home.xlsx
<TBODY>
</TBODY>
ID will be my connection for the two sheets.
i need to create a view that will display somewhat like the following
<TBODY>
</TBODY>
i know this can be done in macros wherein i can have a new sheet with the third table but what i want to know is can i achieve this using Pivots. I know how to work with macros but i have never worked on Pivots and i feel this can be one opportunity to do that. I just want to if we can do this in pivots?
I was not sure if this post will come in the Power Pivots thread if so tell me how to migrate it there and ill do it.
Thank you in advance.
I am asked to make a macro for the following:
i have two sheets where in one sheet say Home.xls has few columns in it like
ID | Name | Project | Role | H-RM |
jdjs87 | Jain Abraham | XYZ | BA | ABC |
kkkj03 | ABC | kqr | Manager | UVW |
<TBODY>
</TBODY>
and the othe sheet say Away.xlsx has simillar columns with only ID similar to the one in the Home.xlsx
ID | Name | A-RM | Start date ... |
jdjs87 | Abraham Jain | KJB | 12/12/2014 |
djfkaj | LMN | JKL | 09/12/2014 |
<TBODY>
</TBODY>
ID will be my connection for the two sheets.
i need to create a view that will display somewhat like the following
ID | Name | H-RM | A-RM | Project | Start Date |
jdjs87 | Jain Abraham | ABC | KJB | XYZ | 12/12/2014 |
kkkj03 | ABC | UVW | JKL | kqr | 02/20/2014 |
<TBODY>
</TBODY>
i know this can be done in macros wherein i can have a new sheet with the third table but what i want to know is can i achieve this using Pivots. I know how to work with macros but i have never worked on Pivots and i feel this can be one opportunity to do that. I just want to if we can do this in pivots?
I was not sure if this post will come in the Power Pivots thread if so tell me how to migrate it there and ill do it.
Thank you in advance.