Automatticly copy values only

[miicker]

Hello everyone,

I have a question, how can I automaticly Copy values from A1:A50 to B1:B50 (values only)

So I have a form like this:

A1 (2-1)
A2 (3-1)
etc..

And I want:
B1 1
B2 2
etc..

So I can hide column A and users will not see any formula.

Kind regards,
Miicker

 

[miicker]

Hello, I have one question:

The values do not automatticly paste when I use formulas
So in A1:A150 are formulas, when the value changes, the macro is not triggered, how can I solve this?

Kind regards,
Miicker