Want to move the data of a cell to another cell on the same row.

[guidom]

I want to move the data of a cell to another cell on the same row, and leave the original cell empty.

See attachment.

moving.xlsm

GuidoM

[pareshj]

Hi,

Check the attached file and hope this is what you want.

moving.xlsm


Regards,
Paresh J

[guidom]

That's exactly what i wanted, many thanks.

GuidoM

[pareshj]

Hi,

If you think you got your solution then Click * to Add reputation as way to say thanks and mark this thread as SOLVED


Regards,
Paresh J

[guidom]

I did.

GuidoM

[guidom]

Hi Pareshj

Is it possible that if cell which i want to move to the right is empty then do not move.

GuidoM

[pareshj]

Hi,

Does that matter because then you will bemoving empty A2 cell to E2. But if still you can stop that by checking

Please Login or Register  to view this content.

Regards,
Paresh J

[guidom]

It matters, because if you press that button twice the value is gone

GuidoM

[pareshj]

Hi,

OK you can use the code in my post#7.

[guidom]

Perfect!!

GuidoM

[nilem]

as an option

Please Login or Register  to view this content.

[guidom]

Nilem and Pareshj both codes works perfectly.

I do not know if i should make a new thread, but would it be possible that the right column where the names are moved to , be arranged so the names are all beneath eachother without empty cells.

GuidoM

[nilem]

Hi GuidoM,
try this

Please Login or Register  to view this content.

[guidom]

Hi Nilem,

Thanks, it works.

GuidoM