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
[TABLE="class: grid, width: 500, align: left"]
<TBODY>[TR]
[TD]ID
[/TD]
[TD]Name
[/TD]
[TD]Project
[/TD]
[TD]Role
[/TD]
[TD]H-RM
[/TD]
[/TR]
[TR]
[TD]jdjs87
[/TD]
[TD]Jain Abraham
[/TD]
[TD]XYZ
[/TD]
[TD]BA
[/TD]
[TD]ABC
[/TD]
[/TR]
[TR]
[TD]kkkj03
[/TD]
[TD]ABC
[/TD]
[TD]kqr
[/TD]
[TD]Manager
[/TD]
[TD]UVW
[/TD]
[/TR]
</TBODY>[/TABLE]
and the othe sheet say Away.xlsx has simillar columns with only ID similar to the one in the Home.xlsx
[TABLE="class: grid, width: 500, align: left"]
<TBODY>[TR]
[TD]ID
[/TD]
[TD]Name
[/TD]
[TD]A-RM
[/TD]
[TD]Start date ...
[/TD]
[/TR]
[TR]
[TD]jdjs87
[/TD]
[TD]Abraham Jain
[/TD]
[TD]KJB
[/TD]
[TD]12/12/2014
[/TD]
[/TR]
[TR]
[TD]djfkaj
[/TD]
[TD]LMN
[/TD]
[TD]JKL
[/TD]
[TD]09/12/2014
[/TD]
[/TR]
</TBODY>[/TABLE]
ID will be my connection for the two sheets.
i need to create a view that will display somewhat like the following
[TABLE="class: grid, width: 300, align: left"]
<TBODY>[TR]
[TD]ID
[/TD]
[TD]Name
[/TD]
[TD]H-RM
[/TD]
[TD]A-RM
[/TD]
[TD]Project
[/TD]
[TD]Start Date
[/TD]
[/TR]
[TR]
[TD]jdjs87
[/TD]
[TD]Jain Abraham
[/TD]
[TD]ABC
[/TD]
[TD]KJB
[/TD]
[TD]XYZ
[/TD]
[TD]12/12/2014
[/TD]
[/TR]
[TR]
[TD]kkkj03
[/TD]
[TD]ABC
[/TD]
[TD]UVW
[/TD]
[TD]JKL
[/TD]
[TD]kqr
[/TD]
[TD]02/20/2014
[/TD]
[/TR]
</TBODY>[/TABLE]
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
[TABLE="class: grid, width: 500, align: left"]
<TBODY>[TR]
[TD]ID
[/TD]
[TD]Name
[/TD]
[TD]Project
[/TD]
[TD]Role
[/TD]
[TD]H-RM
[/TD]
[/TR]
[TR]
[TD]jdjs87
[/TD]
[TD]Jain Abraham
[/TD]
[TD]XYZ
[/TD]
[TD]BA
[/TD]
[TD]ABC
[/TD]
[/TR]
[TR]
[TD]kkkj03
[/TD]
[TD]ABC
[/TD]
[TD]kqr
[/TD]
[TD]Manager
[/TD]
[TD]UVW
[/TD]
[/TR]
</TBODY>[/TABLE]
and the othe sheet say Away.xlsx has simillar columns with only ID similar to the one in the Home.xlsx
[TABLE="class: grid, width: 500, align: left"]
<TBODY>[TR]
[TD]ID
[/TD]
[TD]Name
[/TD]
[TD]A-RM
[/TD]
[TD]Start date ...
[/TD]
[/TR]
[TR]
[TD]jdjs87
[/TD]
[TD]Abraham Jain
[/TD]
[TD]KJB
[/TD]
[TD]12/12/2014
[/TD]
[/TR]
[TR]
[TD]djfkaj
[/TD]
[TD]LMN
[/TD]
[TD]JKL
[/TD]
[TD]09/12/2014
[/TD]
[/TR]
</TBODY>[/TABLE]
ID will be my connection for the two sheets.
i need to create a view that will display somewhat like the following
[TABLE="class: grid, width: 300, align: left"]
<TBODY>[TR]
[TD]ID
[/TD]
[TD]Name
[/TD]
[TD]H-RM
[/TD]
[TD]A-RM
[/TD]
[TD]Project
[/TD]
[TD]Start Date
[/TD]
[/TR]
[TR]
[TD]jdjs87
[/TD]
[TD]Jain Abraham
[/TD]
[TD]ABC
[/TD]
[TD]KJB
[/TD]
[TD]XYZ
[/TD]
[TD]12/12/2014
[/TD]
[/TR]
[TR]
[TD]kkkj03
[/TD]
[TD]ABC
[/TD]
[TD]UVW
[/TD]
[TD]JKL
[/TD]
[TD]kqr
[/TD]
[TD]02/20/2014
[/TD]
[/TR]
</TBODY>[/TABLE]
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.