MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help please on Linking Formulas!

Posted by Chris on April 26, 2001 11:19 AM

I have a speadsheet with many tabs in it, each containing the same formula (for example: p6..p135).Is there a way for me link it so that if I for instance change the formula to (p6..p140) all speadsheet's formuals will be updated in the same way?

Thank you.

Posted by Barrie Davidson on April 26, 2001 11:46 AM

Select all the sheets you want to change the formula in and then type the new formula in the active sheet. The same formula will be entered in all the selected sheets. If you need any help doing this let me know.

Posted by Aladin Akyurek on April 28, 2001 6:33 AM


Care to post the formula that you use?