Automatically update only with numbers(ifnumber-update and go to next cell)

[moldo89]

Hello everyone,
I'm back with a problem I can't solve:
Let's say that in column A I have numbers,"Yes" and "No". I want in column B to have only the numbers from column A, in the same order without any empty ranges, and everytime I add in column A a new number, column B to update automatically with that number. Let's have an example:
A B
Yes 12
12 13
No 10
13
No
10
Yes

And if I want to add in column A:
A B
Yes 12
12 13
No 10
13 25
No 15
10
Yes
25
15
So the column be will update automatically. Something small would be great cause I need to use this many times for many rows and columns so I don't want to make my file heavy.

Thank you!

[Fotis1991]

moldo89

Welcome to the forum.

I suggest to take some minutes to tead forum rules.

Don't start same threads in 2 sub forums. It's duplicate thread. In your case as your issue looks that need a VBA code pm to an active moderator to remove your thread. I mooved for this time your other thread in VBA sub forum and i close this one as duplicate. So:


Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.