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

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi,

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

Rgds,

Andreas

Perhaps Copy Paste ?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

No way, must been automatically....

Try this:

In A4 enter: =($A1)

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

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

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?

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

A1 is never changing. Nothing is done with it.

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

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

Option Explicit

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2505