Need Macro to match two different columns and inserting blank rows

**michael.adams2** · 05-05-2017, 12:48 PM

I am trying to match two different columns (Columns B and E) and line them up if there is a match. If there is not a match I would just want a blank in that portion.

Issue I have is that Columns B and E are not an exact match. Entry in Column B says ABC Communications, while entry in Column E just says ABC Comm. But I would still like them to line up. Is there a way to do a match based on the 1st word in that column?

Appreciate the help!

Currently have:
Capture1.PNG

Would like:
Capture2.PNG

**dflak** · 05-05-2017, 04:33 PM

This could be done with a pivot table. One of the options is to add blank lines after a group.

Need Macro to match two different columns and inserting blank rows

LinkBack

Thread Tools

Rate This Thread

Display

Need Macro to match two different columns and inserting blank rows

Re: Need Macro to match two different columns and inserting blank rows

Thread Information

Users Browsing this Thread

Similar Threads

How to insert rows and columns in other sheets by inserting rows and columns in one sheet?

[SOLVED] Inserting Blank Columns between existing non Blank columns

[SOLVED] Macro to scan rows and columns to replace values with a blank

Macro to create sub total as also inserting blank rows after each subtotal

[SOLVED] Obtaining values from equally spaced columns and inserting in rows where they match

Inserting blank rows ...

Inserting Blank rows after every row upto 2500 rows

Bookmarks

Bookmarks

Posting Permissions