macro to copy paste non empty data

P

paritoshmehta

Hi,

I have a column where names are entered (column A) and then some value
are entered and in column Z, the sum of all the values entered i
displayed....

I was wriring a macro to copy the non empty cells in column A, and i
is working fine(select the first cell and do a end down selection)...
i am facing difficulty in writing code to copy the non empty cells i
column Z, this is because the cells have a sum formula and the no
empty... please help...

Also, If i want some code to run if A1 is non empty, then what shoul
be the code like
 
Top