Fixing A Data Export Issue

[McNulty]

Hi

I have a bit of a bizarre problem when exporting data out of a certain system. There is a known bug where sometimes it splits data, that should be on 1 line, across 2 lines. It's always done in the same way, and I'd like to write a macro to do the following:

- Search column B for "12"
- If it finds it, highlight the 11 cells next to it (including that cell), and cut it
- Find the next populated row up, move along to column L and paste it

I'm not sure I can do this all in one step, or if I need to move cell by cell. But any help on this would be fantastic.

Cheers.

[StephenR]

So, are you saying that in your example B7:L7 would be moved to L5?

[McNulty]

Hi Stephen - exactly. But obviously my data export is a lot larger, and can happen multiple times across the board. I can write something to delete blank rows so that isn't really a concern.

[StephenR]

Try this. The last line deletes blanks so remove if you don't want that.

Please Login or Register  to view this content.

[McNulty]

That's superb, had to amend the 12 to match my actual data and wrap it in quotes, but the code works perfectly. Thankyou so much.