Shift cells left

Hi Guys, I have values in columns R and S - where there is a blank cell in in Col R i'd like to move the values there from Col S.

Could someone please help? many thanks

I tried the below but alas....!!!

Please Login or Register  to view this content.

Shouldn't that be Columns("R:R") rather than Columns("S:S")?

yes................................!!! arggghhhhhh!!!!

Hi Rory, will this work if the data is in a table? I dont want to shift the whole table. Just s to r where relevant? Cheers dude

Arh - the operation is not allowed - it is attempting to shift columns from a table!! Do you know a way to overcome this?

Many thanks

You'd have to loop and transfer the values then clear the column S values.

cheers mate, loopings a ball ache but i'll give it a crack!. Hope all well with you. Have a good day