HI,
can anybody tell me that i have two workbooks. iand i want to synchronize data from Book1.xls,Sheet1! to book2.xls,sheet1! but i have many zones of working, i want i just get the complete data of zone A.

Zone A is shown in many cells, just get data of cells found Zone A.

Please help.