Hello all Gurus!,

I am attempting to write a Macro for the following seperate
cells:

='Borgo Salcetino DI'!$H$34
='Borgo Salcetino DI'!$H$45
='Borgo Salcetino DI'!$H$56
='Borgo Salcetino DI'!$H$67

so the end result would be:
=IF'Borgo Salcetino DI'!$H$34 doesn't have anything in it, then look
in 'Borgo Salcetino Ware'!$H$34

Same for the other 3 lines and I have mulitple pages of other lines
(34,45,56,and 67 always stay the same) with same setup but not the
same letters to change. Example 'Angels DI'!$G$34

Is this possible to change these cells with 1 or 4 (for each different
column) Macros

Thanks-my head is spinning right now.