Hi all,
Is there a way to copy only all NON BLANK cells in column H on Sheet2 over
to column D of Sheet1 and have this run without having to press a button to
start the macro...have it "live" update?

Thanks!