Macro to move selected cells in a data base

**nico125** · 11-13-2013, 09:24 AM

Hi everyone,
I downloaded a report in a delimited data format. While converting it into Excel, some line automatically are cut and the cells are moved to a new line. This move follows the same number of cells (See the document attached). The initial report includes 220,000 lines and 2,000 must be readjusted.
I have created Macros at a basic level. Would you have any suggestions?
Thanks a lot!

**alansidman** · 11-13-2013, 09:33 AM

This should work for you

Please Login or Register  to view this content.

**nico125** · 11-13-2013, 10:17 AM

Great! It perfectly works! Thanks a lot!

**nico125** · 11-13-2013, 10:21 AM

And to delete the empty row?

**nico125** · 11-13-2013, 10:32 AM

Ok found it! Thanks again

**alansidman** · 11-13-2013, 11:12 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Macro to move selected cells in a data base

LinkBack

Thread Tools

Rate This Thread

Display

Macro to move selected cells in a data base

Re: Macro to move selected cells in a data base

Re: Macro to move selected cells in a data base

Re: Macro to move selected cells in a data base

Re: Macro to move selected cells in a data base

Re: Macro to move selected cells in a data base

Thread Information

Users Browsing this Thread

Similar Threads

Move selected cells to corresponding cells in a new column

[SOLVED] Move selected cells to previous row

Move cells down to a selected cell

Macro to copy data from csv file base on cells in existing workbook

display data in graphs base on selected priority

Bookmarks

Bookmarks

Posting Permissions