Quote Originally Posted by omletto View Post
For your second question, if you hold ctrl and highlight all the tabs you want to change, the change the info on first sheet, it should alter all the sheets providing the layout is the same.
i first select the entire sheet then i make alteration

i m doing this because there are some sheets on which i dont want to make the alteration so first i select my desired sheet and then i play on one sheet

it dosent change if the formula is already entered in sheet one
i tried it many times.

it works only if erase the formula and type the formula again manually