Excel population

[DAWG2006]

Is there anyway to get a cell (A12) to populate something from another cell (AE30) without entering a formula into the original cell (A12).

Thanks in advance

 

[Gerald Higgins]

So are you saying you want something to appear in cell A12, based on what is in AE30, and A12 must not contain a formula ?

If so, no, I don't think you can do this, unless you want to copy and paste the AE30 value into A12, either manually or using a macro.

 

[lenze]

With code!!

Private Sub WorkSheet_Change(Byval Target as Range)
If Target.Address <> "AE30" Then Exit Sub
Range("$A$12") = Target
End Sub

lenze

 

[DAWG2006]

Well here's the follow up question, is there any way to get it to populate with the formula in A12, but when I delete what was populated the formula remains?

 

[Gerald Higgins]

The formula will in A12 will remain if you delete what was in another cell.
Are you saying you want the VALUE calculated by the formula to remain ?
Again, only by copy pasting the value in, either manually or with a macro.

Try Lenze's suggestion.

 

[DAWG2006]

How do you set up a Macro for that?


right now it's being populated by a vlookup





Delete the Value of A12 but having the formula remain.

 

[DAWG2006]

Bump