Setting cell referencing to different workbook:

[pedie]

Hi,

In book1 and Data.xlsm i have sheets with same names and equal numbers of sheets.
from book 1 i am settings cell referencing of book2 sheet1 A1:C200 for sheet1 A1:C200. which looks like this for now

=IF([Data.xlsm]MayDat1!A1="","",[Data.xlsm]MayDat1!A1)

here MayDat1 is the name of the current sheet and also name of sheet in Data.xlsm
I need a vba to set cell refercing like this for all the sheets if sheet name matches in Data.xlsm with this workbook names.
If this is possible then please suggest.

Thanks Pedie

 

[pedie]

All set.

Have a great weekend!