What should be used in the following situtation Pivots or Macro

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
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.
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,123,535
Messages
5,602,217
Members
414,513
Latest member
junbuggle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top