Moving text from one range of cells to an empty row in the same sheet:

Here's my situation:

1.) I have no idea how to code a macro.
2.) I've run a macro successfully that added an empty row below each already filled row.
3.) I have a database of information with two sets of contact information in one row, B - Name, C - Title, D- Email, E - Phone, and F - Name, G - Title, H- Email, I - Phone
4.) I'm trying to move the second set of contact information to the empty row below.

So, if I have columns B C D E already in place, how do I move the cells in F G H I below B C D E?

Any help is greatly appreciated! If I had any idea what I was looking at in other answers, I would have put together a macro of my own, but it's a completely foreign language.

Thank you!

-Ashley

Please upload a sample of the data in a workbook with two worksheets: one with the original data sample and one with the data arranged how you'd like. I'm not sure exactly what you are trying to achieve from your post. It sounds like you would just copy and paste the data but that does not involve a macro so I think I've misunderstood.

Hi Yay,

Yes, it would involve copying and pasting, but with 1,000 records, and ~10 databases, this will take quite a while.

Attached is a spreadsheet with two tabs, the first being what it looks like now, and the second with what I'd like it to look like.

Is there not a macro that would run this repetitive process?

Thanks so much for your reply,
Ashley

Sample.xlsx

Provided the sample data is in the exact same format as the worksheet you uploaded (data is in the same columns and always follows the one-entry-then-one-blank-row pattern), this code will update the active worksheet of your database.

Please Login or Register  to view this content.

Good luck!

Awesome! Thank you so much. I was afraid I wasn't asking a macro question with your first reply, but I'm glad it can be done. I will try this out.

If the data is in a different column, simply change the range referenced in the code?

-Ashley

---------- Post added at 12:57 PM ---------- Previous post was at 12:50 PM ----------

Also, 1.) It works fabulously. Thank you again! 2.) Is there a way to keep formatting when running the macro? If not, no biggie; it takes just a minute to reformat things, but it would be cool if that could be added in the code somehow.

Thanks again!

It is probably faster to format as you like after running the macro rather than apply formatting to every line as the code loops through the entries. I'm glad it works for you.

If the data is in different columns, changing the letters will work for you as long as the source data columns are in the same order as the destination columns. Does that make sense?

I guess it was just the data I was working with.. When I pasted the values in a new spreadsheet the macro worked fine. Sorry to bother you!

-Ashley