Updating new inserted sheet in excel

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.

Why, out of interest, are you averse to having the string stored as the result of a formula as opposed to a hard-coded value in a cell?

updating new inserted sheet in excel-87updating new inserted sheet in excel-71updating new inserted sheet in excel-11

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.

ADO can’t access the data source directly, it will take help of OLE DB Provider to communicate with the data source.

Most of the times OLE DB providers are specific to a particular Data Source Type.

In any case, my previous exaple should acheive what you want to do.

Just type in cell B5: =IF($A="yes","Work Done,"") Run the Update Val macro (Alt F8) and the hard-coded string "Work Done" will be in cell A5.

Value End Sub Private Sub Worksheet_Change(By Val Target As Range) Update Val End Sub and it works but it keeps giving a Method range of object worksheet failed error, can you help.

ADO Stands for Active X Data Objects, is Microsoft’s Client-Server technology to access the data between Client and Server.

Active subscribers of Spreadsheet Gear can download this hotfix from the Licensed Users Downloads page.

Tags: , ,