Copy specific cell to new worksheet but keep original cell value
Trying to copy a specific cell(s) from sheet 1 to sheet 2 when a value in said cell changes. example: part 1. sheet1 cell B2 value=1 sheet1 cell E2 Value is 10 Copies value from sheet1 cell B2 and sheet1 cell E2 to worksheet2 cell B2 and E2 part 2. Sheet1 cell B2 Value changes to 2 sheet1 cell E2 Value is 20 copies new value from sheet1 cell B2 and E2 to sheet2 but moves new value down 1 cell to B3 and E3 but also leaving sheet2 cell B2 and cell E2 as is. So everytime the value of sheet1 B2 and E2 changes, it copies that new changes to sheet2 but moves the new values down one row. Thank You for any help.
HELP: cell copied is deselected when clicking on formula bar.
MY PROBLEM The behaviour of excel seems different today, I can’t copy and paste a value directly on the formula bar any longer. When I copy a cell, it appears the usual dashed line to highlight that the cell is copied. As soon I click the Formula Bar, when any cell is selected, the dashed line disappears, and by clicking ctrl+V no value is pasted on the formula bar. I’m using Office 365, desktop version. HOW I TRIED TO SOLVE THE ISSUE I have just tried to restart the computer; I don’t know what else to try. WHAT I USED TO DO AND WHY When I need to copy a value (not formulas) from cell X to cell Y, I used to copy the cell X and paste the value directly on the formula bar of cell Y. I know that I could use Paste Special to paste only values, but the behaviour is different, and I prefer to copy directly on formula bar. For example, if in cell X the value is 1,000000005, and the cell is formatted to show only 2 decimals, I have two different value in cell Y if I paste to formula bar and or use Paste Special; if I copy and paste the value in cell Y with paste special, the value of cell Y is 1,000000005, and I need to format the cell to show only 2 decimals; on the contrary if I copy and paste on formula bar of cell Y, the pasted value is exactly 1,00, regardless of how I format cell Y. Sometimes I need the original value, sometimes I need the value already rounded; that’s why I don’t want to use paste special, but I would like to paste on formula bar. Moreover, by copying values on formula bar, instead of using paste special I also save a few clicks.