Hello,
I have a worksheet with detail data in sheet1 that I'd like to pull over
email add'y in sheet2 if cells in colA are null. Can this be done via a
formula or vba? I'm currently using a pivot table but because we have such a
large volume of data we have poor performance.

COL A COL B COL A (sheet2)
0609
0609
0607
0609

Thank you!
Cathy