VBA code to move data to a cell only if not blank

[joannakf]

I need to move the contents from column E to Column H only if column E has data. If not the text in column H needs to stay. Can anyone help me?

thanks in advance!

[JieJenn]

Try

Please Login or Register  to view this content.

[joannakf]

This doesn't seem to work....I entered as below

Please Login or Register  to view this content.

[jeffreybrown]

Question >> do you have phone numbers in column E that you want to move to column H, but only if column H is currently blank, or do you want to move the phone number when the user enters it in column E and not column H?

[Irish RayRay]

Hi im pretty new to all this and not sure if this will help but from what I understand this should help.

Please Login or Register  to view this content.

You could probably change this to cut instead of copy.
This is for a button but it would be pretty easy to do it so it runs if there is something entered into E4.

Sorry understand what you wanna do now this wouldn't really help.

[joannakf]

The phone numbers will only show up either in column E or H, not both. So I want to move the phone numbers in column E to column H anytime they show up in column E, column H will always be blank when this occurs. So it could be written either way you mention above.

[jeffreybrown]

The code JieJenn supplied works for me.

When you say it didn't work, what happened? Any error? If an error, did you get a debug and if you hit debug what does it highlight?

Also, the code supplied uses column A to look for the last row. Is this row populated as in your example?