Copying cells to the neighbouring column in pairs along Row 1

Originally Posted by royUK

Try this

Please Login or Register  to view this content.

Ok that kinda works. It does it all except the last entry, is there an easy way to get that done?

Many many thanks!

Tim

Ahh another problem, sometimes they aren't actually empty, it's like every even column (B, D, F, H, J, L, N, P...) wants to be copied to the next odd one, rather than just filling in when empty.

Thanks,

Tim

It's almost right, something isn't right however in my spreadsheet, I'm trying to work out what I need to change, I'll get there eventually!

Thanks,

Tim

Yes yes, it does in that spreadsheet. i just can't figure why it isn't working in my main one, but unfortunately I can't give you that! It's something to do with having multiple sheets and it seems to always do one of the wrong ones.

Tim

Originally Posted by royUK

The code that I have given you will only work on the active sheet. You never mentioned multiple sheets

It should be the active sheet though, is there something easy that can be done to ensure it does it specifically for the sheet called "output", I can't seem to crack it, and it's rather annoying because every time it goes wrong of course I have messed up the data on an important sheet!

Thank you for your help!

Tim

Ok I've got it, thanks!