in column a , from a2 i have dates

in column b , from b2 , i have stock price

in column c , from c2 , i have nasdaq values

my data length will change ....may be 100 rows of data or 10000...

what i m looking for is a macro do to :

if values in cells in column c are 0

then in column d i want those dates
in column e i want corr values from column b and in column F i want column c
values....


sam