Hi sb,

If I understand correctly, make sure your initial formula does not
contain absolute references, and then just make a normal copy-paste ...

HTH
Cheers
Carim



sb wrote:
I have more than 50 columns, how I can make each column condition is column
dependent ? instead do column by column. I try use the paste special , it
doesn't work, it just copy all formula over from the first column.