Adding fields to formula at one timeClosed

Question

Hi guys,

Not sure if there's a quick way for this: Do you know if possible to do this:
Sheet 1 A1 field contains formula: sheet 2 A1 plus sheet 3 A1. Is there a way to add sheet 4 A1 to that cell? Obviously what I mean is that I have a lot of formulas in sheet 1 and i would like to add to those formulas an additional tab's values at one time. So everywhere where I had a formula for example sheet 2 F5 plus sheet 3 F5 now it would have plus sheet 4 F5 as well.
I just don't want to go to every single cell and type plus sheet 4 F5 etc. 
Would appreciate any ideas. 

Thanks so much

TrowaD · Answer

Hi DG83,

You can give this a try (not sure with the limited info given; types of formula, formula locations):
- With the combo "Ctrl+t", Excel displays formula instead of result. 
- Select your formula cells and hit the combo "Ctrl+h" to open the find and replace window.
-  Enter the last part of your formula to 'find' "plus sheet 3 F5" and 'replace' it with "plus sheet 3 F5 plus sheet 4 F5".
- Hit the combo "Ctrl+t" to display the results again.

Will this work for you with the formula's you have?

Best regards,
Trowa

Adding fields to formula at one time

1 response

Similar discussions

Subscribe To Our Newsletter!