transfer data

[reuv]

how do i transfer data from datasheet 1 in any of cells b1 till b10 to the specific cells in sheet 2 (b1 till b10), with the condition that if let's say b2 contains data, it transfers automatically text in a2 from sheet 1 to a2 in sheet 2 as well? if the b-cells in sheet 1 stay empty, the a-cells also do not get transfered
thanx

[mdbct]

Please see attached workbook. The formula in Sheet 2 cell A1 is:

Please Login or Register  to view this content.