R Reynolds Nov 29, 2008 #1 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?
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?
S Shane Devenshire Nov 29, 2008 #2 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
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
