I am trying to copy cells
A1
A2
A3
A4...and so on...
from Sheet1 to Sheet2, is there any easy way to copy all
cells at one time since I am trying to copy by using =Sheet1!A1,
one at a time!

Also I note that the empty cells in Sheet1 shows zero (0) in Sheet2 ,
I would like those cells to be empty as well.

Need help with this....please

cell Sheet1!B1:C1 is a date

=IF(D2="","",(Sheet1!B1:C1))....returns #VALUE

=IF(Sheet2!D2="","",(Sheet1!B1:C1))....returns blank cell