Combine worsheet data

[pac0cxd]

Hi Experts,


I need your expertise to help me to speed-up creation of this report. Currently, I have 1 spreadsheet of Demand and 1 spreadsheet of Supply. What needs to be done is to join both data into one table to compare and compute gap of our demand and supply. It’s a simple thing though but it is so tedious where I know I can create it in just one click. Kindly refer to the attached for a clear picture of the result I wish to aim.

I am currently doing a research on how to do this but if you have some ready sample codes or direction how to do this, It will be a very big help.

Thanks so much in advance.

[FDibbins]

Hi

You dont need VBA for this (That is where you posted this)

for the green table, use this, copied down and across...
=INDEX($D$10:$G$16,MATCH($B20,$B$10:$B$16,0),MATCH(D$19,$D$10:$G$10,0))

for the pink table, use this, copied down and across...
=INDEX($D$2:$G$8,MATCH($B20,$B$2:$B$8,0),MATCH(H$19,$D$2:$G$2,0))

[pac0cxd]

Thank you so much for your reply! :-)

I checked your code and its working fine. But in addition, kindly refer again with my attached file, I need to combine data from demand worksheet and supply worksheet where if example: Level Manager is existing in demand and not existing in supply, the result will include Level Manager in the list where it has values in Demand column section(green) and 0 values(shaded in violet) in supply column section (pink).

I really appreciate your help again :-)

[FDibbins]

to include items that do not exist in the other table, wrap the formula in iferror()...
=IFERROR(INDEX($D$2:$G$8,MATCH($B20,$B$2:$B$8,0),MATCH(H$19,$D$2:$G$2,0)),0)