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

One way :
Enter your formula as described above =Sheet1!A1 then pull down the handle at the lower right corner of the cell where you entered the formula as far as needed
Using IF with range will not work
As for the cells containing a 0, is there a formula in them, and which is it?
You can eventually check " do not show zero values " in the XL options

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Perhaps try http://www.rondebruin.nl/win/addins/rdbmerge.htm

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post