Hi All,
+SUMIF('account_type_transactions (2)'!T:T,account_transactions!T2,'account_type_transactions (2)'!O:O)
Here i want to change the account_type_transaction T:T to absolute in the whole file where ever it appears. I have 3 sheet tabs containing this formula for 100 rows for each sheet.
I need a function or sub routine.
Bookmarks