Adding fields to formula at one time

Closed
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018
-
Posts
2849
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 27, 2022
-
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

1 reply

Posts
2849
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 27, 2022
491
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