Afternoon all,

I’m creating a Master Comparision Table in Excel worksheet which links information from 4 pivot tables. The 4 tables are archived from 4 queries in 1 MS access file called CPA.mdb file, since I’m having a large MS access file then can’t join the 4 table in a query. Have to create a query in a pivot table 1 on 1. The field selection in each pivot table is customer name. I’d like to automate the following option in the Master Comparison Table;

1. Update customer name list in Combo box in the Master Comparison Table in Excel worksheet, range from Customer name field in Pivot Table A (Table A will be the master source selection)

2. How to return 0 value to the Master Comparison Table in case the Customer in pivot table A is not available in B, C and D.

The Master Comparison Table looks like as follows;

3-Combo box selections: Year Month Customer

Product Turnover Margin

Database Table A xx xx
Database Table B
Database Table C
Database Table D

How to code the two option above. Your advice will be very much appreciated. Or advise the possible way to workaround. I've been hanging with this since last 2 weeks.