Hello Dears,
I have more than 50 tabs (sheets), which I want to link by using VBA with Master tab.
In attached file, I kept one Master Tab & other 1,2,3,4,5 tabs.
For example, Master Tab to tab (1) I linked manually & you can see formula or linking.
Master Tab C7 cell data linking in Tab (1) M2
Once this link ACTIVATED , then resulted data received in G1,G2,G3 & H1,H2,H3 & i1,i2 in TAB 1.
This data need to link in Master tab at E7,E8 & E9 ; F7,F8 & F9; G7,G8 respectively.
Regards Rahul.
Bookmarks