I'm a little confused as to which way data is supposed to be moved. Looking
at your example, I'm thinking you want to get an email address from column A
of Sheet2 and place it into empty cells in column B of Sheet1.

Question is how to decide which one to pull. Is there a one-to-one
correspondence between the rows on both sheets. That is, if Sheet1!B3 is
empty, can we just get the address in Sheet2!B3 to put into it?

By any chance would the numbers shown as being in Sheet1, column A be found
on Sheet2 in association with the appropriate email addresses?


"Cathy Landry" wrote:

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