Help with the Macro.
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.
|