turtlespeed 226 #1 December 17, 2003 What is the formula that I can use if I want to enter data in a cell on one worksheet and have it calculate to another worksheet. Like if on Sheet1 and wanted to take the value that I entered into A1 and have it calculated onto a cell in Sheet2.I'm not usually into the whole 3-way thing, but you got me a little excited with that. - Skymama BTR #1 / OTB^5 Official #2 / Hellfish #408 / VSCR #108/Tortuga/Orfun Quote Share this post Link to post Share on other sites
pilotdave 0 #2 December 17, 2003 Easiest way is to just enter = in the destination cell, then go click on the cell you want to take data from. It'll give you the correct wording that way. Dave Quote Share this post Link to post Share on other sites
ladyskydiver 0 #3 December 17, 2003 Go to Sheet 2. Click on the cell you want the value calculated into. Put in that cell: =sum(Sheet1!A1:A3) Sheet1! would be which sheet the values are coming from. A1:A3 would be the range of the values that you want calculated. Have fun.Life is short! Break the rules! Forgive quickly! Kiss slowly! Love truly, Laugh uncontrollably. And never regret anything that made you smile. Quote Share this post Link to post Share on other sites
racer42 0 #4 December 17, 2003 I believe what you are asking is only in the theoretical stage of development. This may take years and millions of valuable IT dollars.L.A.S.T. #24 Co-Founder Biscuit Brothers Freefly Team Electric Toaster #3 Co-Founder Team Non Sequitor Co-Founder Team Happy Sock Quote Share this post Link to post Share on other sites
turtlespeed 226 #5 December 17, 2003 OK, now here's another one - what about if you want it to transfer data to a whole other workBOOK?I'm not usually into the whole 3-way thing, but you got me a little excited with that. - Skymama BTR #1 / OTB^5 Official #2 / Hellfish #408 / VSCR #108/Tortuga/Orfun Quote Share this post Link to post Share on other sites
rehmwa 2 #6 December 17, 2003 Go to the help section and study up on links and, especially, external reference. (look up 'reference' in the index under help). That'll get you there. ... Driving is a one dimensional activity - a monkey can do it - being proud of your driving abilities is like being proud of being able to put on pants Quote Share this post Link to post Share on other sites
ladyskydiver 0 #7 December 17, 2003 Easiest way is to do it step-by-step with Microsoft's Help Index open. Out of Microsoft's Help Index: Create a name that refers to cells in another workbook When you define a name that refers to a cell or range of cells in another workbook, you create a link known as an external reference. When you do this procedure, make sure the workbook you want to refer to is open and that it has been saved. 1. In the workbook in which you want to create the external reference, point to Name on the Insert menu, and then click Define. 2. In the Names in workbook box, enter the name for the external reference. 3. If the Refers to box contains a reference, select the equal sign (=) and the reference and press BACKSPACE. 4. Activate the workbook that contains the cell you want to refer to by clicking the name of the workbook on the Window menu. 5. Select the cell or range of cells you want to refer to. 6. In the Define Name dialog box, click Add. Viola!Life is short! Break the rules! Forgive quickly! Kiss slowly! Love truly, Laugh uncontrollably. And never regret anything that made you smile. Quote Share this post Link to post Share on other sites
turtlespeed 226 #8 December 17, 2003 QuoteEasiest way is to do it step-by-step with Microsoft's Help Index open. Out of Microsoft's Help Index: Create a name that refers to cells in another workbook When you define a name that refers to a cell or range of cells in another workbook, you create a link known as an external reference. When you do this procedure, make sure the workbook you want to refer to is open and that it has been saved. 1. In the workbook in which you want to create the external reference, point to Name on the Insert menu, and then click Define. 2. In the Names in workbook box, enter the name for the external reference. 3. If the Refers to box contains a reference, select the equal sign (=) and the reference and press BACKSPACE. 4. Activate the workbook that contains the cell you want to refer to by clicking the name of the workbook on the Window menu. 5. Select the cell or range of cells you want to refer to. 6. In the Define Name dialog box, click Add. Viola! Cora, ok, pretend that I'm in fifth grade (prolly not a good analogy) but lets pretend. Could you give me an example. Pretty Please. (Man I feel Dumb)I'm not usually into the whole 3-way thing, but you got me a little excited with that. - Skymama BTR #1 / OTB^5 Official #2 / Hellfish #408 / VSCR #108/Tortuga/Orfun Quote Share this post Link to post Share on other sites
pilotdave 0 #9 December 17, 2003 Do it the same way I suggested before. Lets say you want data from Book1 to appear on Book2. Go to the cell you want to put the data on book2. Type "=". Then go to Book1, find the cell you want to take data from, and click on it. Then press enter. Your cell in book2 will now contain: =[Book1]Sheet1!$A$1 (or whatever the book is called and the selected cells are). Dave Quote Share this post Link to post Share on other sites
turtlespeed 226 #10 December 17, 2003 it didn't work like that for me.I'm not usually into the whole 3-way thing, but you got me a little excited with that. - Skymama BTR #1 / OTB^5 Official #2 / Hellfish #408 / VSCR #108/Tortuga/Orfun Quote Share this post Link to post Share on other sites
pilotdave 0 #11 December 17, 2003 Ok, well the format is still the same... "='C:\path\[filename.xls]sheetname'!$G$9" Be sure to use those single quotes surrounding the path to the sheet name when you're using a whole path in the reference. Dave Quote Share this post Link to post Share on other sites
turtlespeed 226 #12 December 17, 2003 ok, it worked . . . . . . . . . I'm not usually into the whole 3-way thing, but you got me a little excited with that. - Skymama BTR #1 / OTB^5 Official #2 / Hellfish #408 / VSCR #108/Tortuga/Orfun Quote Share this post Link to post Share on other sites
ladyskydiver 0 #13 December 17, 2003 ** Biting tongue ** Ok...let's start out at the basics. What are you trying to do? Display text from one workbook into another? Sum data? What? Edited: Ignore this post. Just noticed you got it working. Life is short! Break the rules! Forgive quickly! Kiss slowly! Love truly, Laugh uncontrollably. And never regret anything that made you smile. Quote Share this post Link to post Share on other sites
turtlespeed 226 #14 December 17, 2003 Thanks, and yeah, fifth graders are prolly better at this than me.I'm not usually into the whole 3-way thing, but you got me a little excited with that. - Skymama BTR #1 / OTB^5 Official #2 / Hellfish #408 / VSCR #108/Tortuga/Orfun Quote Share this post Link to post Share on other sites
Casie 0 #15 December 17, 2003 Have you got your problem taken care of yet?~Porn Kitty WARNING: Goldschlager causes extreme emotional outbursts! Quote Share this post Link to post Share on other sites
turtlespeed 226 #16 December 17, 2003 QuoteHave you got your problem taken care of yet? Ummm, well, uh, hmmm, is this a trick question?I'm not usually into the whole 3-way thing, but you got me a little excited with that. - Skymama BTR #1 / OTB^5 Official #2 / Hellfish #408 / VSCR #108/Tortuga/Orfun Quote Share this post Link to post Share on other sites
