Fixing A Data Export Issue

**McNulty** · 12-21-2009, 12:13 PM

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** · 12-21-2009, 12:18 PM

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

**McNulty** · 12-21-2009, 12:26 PM

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** · 12-21-2009, 12:31 PM

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

Please Login or Register  to view this content.

**McNulty** · 12-21-2009, 01:03 PM

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.

Fixing A Data Export Issue

LinkBack

Thread Tools

Rate This Thread

Display

Fixing A Data Export Issue

Re: Fixing A Data Export Issue

Re: Fixing A Data Export Issue

Re: Fixing A Data Export Issue

Re: Fixing A Data Export Issue

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions