Updating new inserted sheet in excel
You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Hi Everyone, I am having a formula in Cell B5 and I want to put the result of this formula in Cell A5. Cell A5 should contain the result of formula written in B5. Then I want to copy the same formula down to other cells . Thanks Hakim I'm not quite sure I understand the motivation for the specific functionality you are requesting. Alternatively, if you are shy of macros, you could run the marginally more manual method of copying cell B5 and then Paste Special as values the result onto cell A5. But I guess its my mistake i didnt explain my problem correctly.
meaning B6 will have formula ($a="yes", A6="work done") . Please help urgently quote: Originally posted by hakimk Hi Everyone, I am having a formula in Cell B5 and I want to put the result of this formula in Cell A5. Cell A5 should contain the result of formula written in B5. Then I want to copy the same formula down to other cells . Thanks Hakim In that case you cannot do specifically what you want with Excel sheet functions alone. Value without manualy typing it all I used the code suggested earlier Sub Update Val() Active Sheet. I need to copy and paste a cell value not the code onto another program that wont allow me to paste just the value, so I need the value moved to another cell and I need it to update when the cell changes.And now this value in B3 should remain Hakim and not change even if the value in A3 changes. So what I want is whatever is the value inserted in the A4 Column by B4 should remain as it is.