link cells in multiple worksheets same workbook with excel vba
Hi all,
I'm trying to link some cells that are in different worksheets (i have
alot of sheets) in the same workbook to a Master worksheet in the same
workbook. I'd like to use vba to do this. The cells to link to are the
same in all worksheets. So for example, in Master worksheet, I need C2
to link to sheet1.C3 and C3 to link to sheet2.C3
Can anyone point me in the right direction on how to do this?
Thanks!
Moon
|