Find solution
How To Select Odd Numbers In Excel?

In Excel how do I copy a number value out of a cell that gets its value from a formula in it and paste it to a?

  • In Excel how do I copy a number value out of a bottom of a sheet that has a formula in it that adds up all the above cells and take that value over to a new duplicat sheet to to place it in an unformulated cell at the top of the new sheet to begin a new session. I'm adding engine times across a selection of parameters for each engine run session for different engines on one sheet. Each one sheet is for one days operation. I am having to sit there with both yesterdays sheet and todays sheet open and contracted so i can see both sheets and type in the final numbers from the bottom of yesterdays sheet into the top of todays duplicate type sheet. I built all the formuals in the master document. If I select all the way across the row of 7 cells on the protected form on yesterdays sheet (which is protected with the selections of all users can select unlocked and locked cells checked) copy the 7 cells and then paste across the top row of 7 cells on todays form I get #VALUE! in all the 7 cells. If I try cell at a time I still get #VALUE! If for experimentation I copy across one of the upper rows of 7 cells that don't have a formula in it in yesterdays sheet, and paste it in todays sheet, the numbers copy across fine. If I unprotect the sheet everything is exactly the same with same problem. What can I do to copy the number sum from the formulated cells on yesterdays sheet and place it at the top row of 7 on the the new sheet into the unformulated cells. Thanks for any pointers. I will have to show others I work with how to do it.

  • Answer:

    On your new sheet, type the equals sign = in the cell where you want your first result from the day before. Then click on the previous day's sheet and when it opens, click on the total figure you want to be in that cell on your new sheet. Press 'ENTER' Now look at your new sheet and you should find the result is there, do the same for the other 6 cells What you have done is to enter a formula that simply says the cell in the new sheet will be equal to the value in the cell of the previous day's sheet. I think this will work for you.

Mike Robinson at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

ODIMWITD Maybe you don't read and comprehend so well either. If the person was an experienced Excel person they wouldn't be looking for help to make their everday tasks easier. The person said they have a basic sheet they use. And the next day they open a new sheet of the basic format and needs to copy the final data on their sheet they used yesterday to a new basic sheet today. I don't know the answer and am not an Excel expert. But I can understand the issue better than you. Maybe you should change the smile on your username marque to a frown.

Use the Paste Special > Values command rather than regular Paste. It seems you were actually pasting formulas—the #VALUE! error means that the formula can't get a needed value, which happened because the values referred to weren't pasted over. If it isn't necessary to have separate sheets/workbooks for each day, try adding a Date column and keep your data on one sheet.

I am betting you do not read much. Either that or English is not your native language. WOW. It took 15 lines to ask how to have a result value on one sheet appear on another? Really? After 300 - 400 words, I still have only the vaguest idea of WTF you are babbling about. Each sheet is named on the tab on the bottom. My Excel has the sheets' default names Sheet1, Sheet2, Sheet3, etc. If I wanted a formula that was computed in cell C17 of sheet Sheet1 to be reflected in Sheet3 cell A4 then I would go to cell A4 of Sheet3 and type =Sheet1!C17 Well actually that is not true.... What I'd actually do is go to cell A4 on sheet Sheet3 and type = Then I'd switch to sheet Sheet1 and click on cell C17 with the mouse. Finally I'd press the Enter key. This has the same effect as typing =Sheet1!C17 Try it. <edit> The following is the syntax for a cell reference [book_name]Sheet_Name!AA00 where the Workbook book_name appearing in square [ ] brackets is the location of the sheet (which if not present is assumed to be the current workbook) the sheet name is immediately after that and is terminated with a ! sign and the cell is designated as usual. A1 - XFD1048576 (in my copy of Excel), that is my last cell is column XFD and row 1048576. Note that Excel treats local references differently than those from different workbooks When using the point an click method to reference a cell in a different book, Excel will make the cell address 'absolute' by default (meaning cell A1 would be entered as $A$1). While a cell on a different sheet in the same workbook will be relative cell A1 will be cell A1. This inconsistency can be a surprise if unexpected. You may have to edit a reference address to either add a $ or two or to remove them. <hey Mike> It took you 3 lines to 'explain'. Case closed. I'm betting you DO read. OTOH, claiming to understand an issue which you DON'T understand the answer to is at best delusional. <last edit> Please note that the 'only' way to freeze a formula into a value on another sheet is to copy and paste it. Copy then Paste Special →Value. So the only way to have a value rather than a formula in cell A4 of my example is to copy and paste (or run a macro, which IMHO is more trouble than its worth in this case)

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.