transfer data

  • Thread starter Thread starter Joop
  • Start date Start date
J

Joop

Please help

How can I transfer (automaticly) data form one cell to another cell. That
other cell contains no formula or what so ever.
e.g. cell A1 is empty, and cell G6 contains the value 12345. How can I send
this value to cell A1 from cell G6 or any other cell.

Thanks,
Joop
 
You can simpley map the cells...

In cell A1 enter = G6 ... whatever you type in G6 gets reflected in A1.

or use =IF(G6="","",G6) , conditional link displays only if G6 has some
value in it.

Hope this helps you.
 
Thanks Sri for the answer,
but wat I ment is how do I get (automaticly) data in cell A1 without a
formula in A1.
I have seen that it is possible, but I haven't the faintest idea how they
did it.
Regards
Joop
==========
 
Joop

What you saw done was most likely done through event code like the code below.

When you enter a value in G6, that value will be entered in A1.....no formula in
A1.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("G6")) Is Nothing Then Exit Sub
On Error GoTo CleanUp
Application.EnableEvents = False
With Target
If .Value <> "" Then
Excel.Range("A1").Value = Target.Value
End If
End With
CleanUp:
Application.EnableEvents = True
End Sub

This is event code.

Right-click on the sheet tab and "View Code".

Copy/paste the code into that module.


Gord Dibben MS Excel MVP
 
Gordon,
thank you for your help. I'll try it this evening immediately and I am very
hopefull now.
Regards,
Joop
====================
 
Back
Top