ExcelBanter - linking a value from another page or tab in a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - linking a value from another page or tab in a formula (https://www.excelbanter.com/excel-worksheet-functions/211993-linking-value-another-page-tab-formula.html)

Reynolds

linking a value from another page or tab in a formula

How do I take a value from another page in my spread sheet take changes
often and add it to the formula on another page or tab?

Shane Devenshire[_2_]

linking a value from another page or tab in a formula

Hi,

Suppose the changing cell is A1 of Sheet2 then on sheet1 select your
formula, say
=SUM(B5:B100)
and modify it to read
=SUM(B5:B100)+Sheet1!A1

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Reynolds" wrote:

How do I take a value from another page in my spread sheet take changes
often and add it to the formula on another page or tab?

All times are GMT +1. The time now is 10:49 AM.