Hi, I have the following formula in lots of cells:

='Raw Extract'!N102
='Raw Extract'!N103
='Raw Extract'!N104

It basically goes from N4 to N367

I am wanting to replace every cell that has this formula with the following:

=IF('Raw Extract'!$Q102="",'Raw Extract'!$N102,'Raw Extract'!$Q102)

Where the 102 is the constant from the previous formula. There are 20 sheets so doing it individually for 20 sheets on so many cells is going to take a while (copy and paste only works for the formula going down but it goes across also, so i'm hoping a VBA will be easier.

Anyone got any ideas?

Cheers,

John