Pull ALL the data from the first 3 book onto a sheet in the final book (name
the sheet xxx_Data). Remove any blank lines and create a pivot table from
the data. It won't ever display blank lines if you don't want it to.

"sighsky" wrote:

Hi,
I have Four work Books. Three are contain the data and one is to link
those datas from those three work books. Examples.

WorkBook #1. In cell A1 has customer name
A2 has total amount.

WorkBook #2. In cell A1 has customer name
A2 has total amount.

WorkBook #3. In cell A1 has customer name
A2 has total amount.

WorkBook # 4 will link those workbook #1,2,3's Customer name and the total
amount.

But, if some of the workbook doesn't have the customer name and amount. I
don't want it to show on the workbook #4 and not even the empty space. How do
I write the code for this.

Any help would be very appreciated.