Revisions to Reference formulas from one sheet into multiple sheets

Bumped by Community user

occurred Oct 16 at 18:07

Bumped by Community user

occurred Jun 18 at 18:03

Bumped by Community user

occurred Feb 19 at 17:07

Bumped by Community user

occurred Oct 22, 2023 at 17:04

Bumped by Community user

occurred Jun 24, 2023 at 16:06

Bumped by Community user

occurred Feb 24, 2023 at 16:04

Bumped by Community user

occurred Oct 27, 2022 at 14:06

Bumped by Community user

occurred Jun 29, 2022 at 14:05

Bumped by Community user

occurred Mar 1, 2022 at 13:01

Bumped by Community user

occurred Nov 1, 2021 at 12:03

Bumped by Community user

occurred Jul 4, 2021 at 11:08

Bumped by Community user

occurred Mar 6, 2021 at 11:07

Bumped by Community user

occurred Nov 6, 2020 at 10:06

Bumped by Community user

occurred Jul 9, 2020 at 10:06

Bumped by Community user

occurred Mar 11, 2020 at 10:02

Bumped by Community user

occurred Nov 12, 2019 at 10:01

Tweeted twitter.com/StackWebApps/status/1187609844926300163

occurred Oct 25, 2019 at 6:00

formatting

Source Link

edited Oct 9, 2019 at 11:48

phwd

24.1k
34
114
249

I would like to reference (pull in) formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced into.

For example, if I have =SUM(Q2:X2) in a Formulasformulas sheet, I would like to pull that into 10 other sheets (budget A sheet, budget B sheet, etc.) so that it would sum Q2:X2 for each budget sheet it is referenced into, not the Formulasformulas sheet.

I have many budget sheets with the same formulas in the same locations. However, they can change from quarter to quarter. I would like to update the formulas in one place, rather than in each sheet. I think this might be possible with getFormula, but I'm very new to scripting and not sure how I would use that.

I would like to reference (pull in) formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced into.

For example, if I have =SUM(Q2:X2) in a Formulas sheet, I would like to pull that into 10 other sheets (budget A sheet, budget B sheet, etc.) so that it would sum Q2:X2 for each budget sheet it is referenced into not the Formulas sheet.

I have many budget sheets with the same formulas in the same locations. However, they can change from quarter to quarter. I would like to update the formulas in one place rather than in each sheet. I think this might be possible with getFormula, but I'm very new to scripting and not sure how I would use that.

I would like to reference (pull in) formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced.

For example, if I have =SUM(Q2:X2) in a formulas sheet, I would like to pull that into 10 other sheets (budget A sheet, budget B sheet, etc.) so that it would sum Q2:X2 for each budget sheet it is referenced into, not the formulas sheet.

I have many budget sheets with the same formulas in the same locations. However, they can change from quarter to quarter. I would like to update the formulas in one place, rather than in each sheet. I think this might be possible with getFormula, but I'm very new to scripting and not sure how I would use that.

formatting

Source Link

edit approved Oct 9, 2019 at 11:48

pjmg

2k
4
11
19

I would like to reference (pull in) formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced into.

For example, if I have =SUM(Q2:X2)=SUM(Q2:X2) in a Formulas sheet, I would like to pull that into 10 other sheets (budget A sheetbudget A sheet, budget B sheetbudget B sheet, etc.) so that it would sum Q2:X2Q2:X2 for each budget sheet it is referenced into not the Formulas sheet.

I have many budget sheets with the same formulas in the same locations. However, they can change from quarter to quarter. I would like to update the formulas in one place rather than in each sheet. I think this might be possible with getFormula, but I'm very new to scripting and not sure how I would use that.

I would like to reference (pull in) formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced into. For example, if I have =SUM(Q2:X2) in a Formulas sheet, I would like to pull that into 10 other sheets (budget A sheet, budget B sheet, etc.) so that it would sum Q2:X2 for each budget sheet it is referenced into not the Formulas sheet. I have many budget sheets with the same formulas in the same locations. However, they can change from quarter to quarter. I would like to update the formulas in one place rather than in each sheet. I think this might be possible with getFormula, but I'm very new to scripting and not sure how I would use that.

I would like to reference (pull in) formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced into.

For example, if I have =SUM(Q2:X2) in a Formulas sheet, I would like to pull that into 10 other sheets (budget A sheet, budget B sheet, etc.) so that it would sum Q2:X2 for each budget sheet it is referenced into not the Formulas sheet.

I have many budget sheets with the same formulas in the same locations. However, they can change from quarter to quarter. I would like to update the formulas in one place rather than in each sheet. I think this might be possible with getFormula, but I'm very new to scripting and not sure how I would use that.

added 379 characters in body

Source Link

edited Oct 8, 2019 at 22:01

Rwhite118

21
2

I would like to reference (pull in) formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced into. For example, if I have =SUM(Q2:X2) in a Formulas sheet, I would like to pull that into 10 other sheets (budget A sheet, budget B sheet, etc.) so that it would sum Q2:X2 for each budget sheet it is referenced into not the Formulas sheet. I have many budget sheets andwith the same formulas in the same locations. However, they can change from quarter to quarter. I would like to update the formulas in one place rather than in each sheet. I think this might be possible with getFormula, but I'm very new to scripting and not sure how I would use that.

I would like to reference formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced into. I have many budget sheets and the formulas change from quarter to quarter. I would like to update the formulas in one place. I think this might be possible with getFormula, but I

I would like to reference (pull in) formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced into. For example, if I have =SUM(Q2:X2) in a Formulas sheet, I would like to pull that into 10 other sheets (budget A sheet, budget B sheet, etc.) so that it would sum Q2:X2 for each budget sheet it is referenced into not the Formulas sheet. I have many budget sheets with the same formulas in the same locations. However, they can change from quarter to quarter. I would like to update the formulas in one place rather than in each sheet. I think this might be possible with getFormula, but I'm very new to scripting and not sure how I would use that.

edited tags

Source Link

edited Oct 8, 2019 at 21:15

Rubén - Volunteer Moderator - ♦

46.1k
18
100
297

Loading

Source Link

asked Oct 8, 2019 at 18:18

Rwhite118

21
2

Loading

Stack Exchange Network

Return to Question