Formula to copy information from one cell into another sheet

Hi 110mama and welcome to the forum

I believe what you are looking for is the sum() function (maybe that was the K key you were thing about?)

perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

I don't think the attachment will work. Let me see if I can explain better with this example.

Sheet 1: I have a sum in cell D5 and D10
Sheet 2: I have a sum in cell D5 and D10
Sheet 3: I want to place the numbers in the four cells onto this sheet so that I can add them all together for a final sum.


As long as it is taking to try and figure this out, you would think it would be easier to just place the numbers manually. But I will be adding at least 10 pages and I also want to be able to use this feature for other workbooks I will be creating. I'm not sure, but I think it involves using an F key. Wishing I had my MS Office 2012 textbook right about now.

yes, I was just going to say that if all you want to do is reference a cell on another sheet, all you need to do is type = then click on the cell you want top reference (it can be on the same sheet, another sheet, or even another file) then press enter - easy as that