Zahl in ein anderes Feld

[forumseeker]

Hallo!



ich möchte z.B. in Zelle A1 bsp. 1 eingeben, die dann in Zelle A4 erscheint. Ich will aber A4 nicht angreifen. (dann konnte ich ja auf A1 verweisen). Geht das und wenn ja, wie?

Gruss,
Andreas

[Pecoflyer]

Hi and welcome. As this is an English speaking forum, please post in English. There are lots of tools out there to help you. Thanks

[forumseeker]

Hi,

I want to transfer value A1 to e.g. A4 and I do NOT want to write anything in A4.

Rgds,

Andreas

[Pecoflyer]

Perhaps Copy Paste ?

[forumseeker]

No way, must been automatically....

[SnakeDoctor]

Try this:

In A4 enter: =($A1)

That will populate the A1 value in A4 for you, and automatically update it if it changes.

[forumseeker]

this is not way I want to realize that. I do not want to input anything in A4

[NoSparks]

How does A1 obtain its value and is anything to happen with A1 after the transfer ?

[forumseeker]

A1 is never changing. Nothing is done with it.

[NoSparks]

A1 is never changing. Nothing is done with it.

I do not want to input anything in A4.

That being all the information provided,
I'm afraid all I can do is wish you luck.

[SnakeDoctor]

Okay, I'm missing something. Your original message said:

"I want to transfer value A1 to e.g. A4 and I do NOT want to write anything in A4."

To 'transfer' is to move from one place to another. The simple formula I gave you will do that, just replace 'A4' with the destination you want.

Other than that, can be more specific of what you are trying to do? Maybe send a screen shot or picture?

[Pecoflyer]

Originally Posted by SnakeDoctor

The simple formula I gave you will do that, just replace 'A4' with the destination you want.
Other than that, can be more specific of what you are trying to do? Maybe send a screen shot or picture?

I think the OP means that no formula should be used. It is probably possible using VBA ?

[Alansidman]

The only way I see this happening is with VBA. Here is a simple VBA that does exactly what you are requesting.

Option Explicit

Sub Foo()
Dim x As Range
Set x = Range("A4")
x = Range("A1").Value
End Sub