formula arithmetic
Hi folks,
I'm sure the question has come-up before so please bear with me. Here is the basic problem: I have a formula that looks something like this: =sheetname!$E$101 What I want to do is change the cell reference from 101 to 105, i.e. add 4 to the numerical part of the formula. Any ideas? I have hundreds of these formulas that need changing and I would prefer to do a global change rather than do all these manually. Thanks a lot. -R |
All times are GMT +1. The time now is 03:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com