Macro to loop through cell values in a column and format multiple cell values

**Roop** · 06-06-2012, 02:47 PM

Hi Guys,
I have worksheet with a column with mutliple cell values. I am looking for a macro to loop through each cell ina column and do the following:-

If there is only one value in a cell then keep it.
otherwise
If there are multiple entries in a cell then just keep the second entry and delete the first, third, so on.

I have attached a sample sheet with two tabs " Original" and "formatted data" to show what i am looking for.

Any help will be much appreciated.

Thanks.

Roop

**StevenM** · 06-06-2012, 03:59 PM

Backup your data.
Place the code below in a standard module (ask if you don't know what that is).
Run: DeleteExtraItemsInColumnB

Please Login or Register  to view this content.

If you have any questions, please ask.

**Roop** · 06-07-2012, 05:39 PM

Hi Steven,
This works perfect.
Thanks alot.

Roop.

Originally Posted by StevenM

Backup your data.
Place the code below in a standard module (ask if you don't know what that is).
Run: DeleteExtraItemsInColumnB

Please Login or Register  to view this content.

If you have any questions, please ask.

Macro to loop through cell values in a column and format multiple cell values

LinkBack

Thread Tools

Rate This Thread

Display

Macro to loop through cell values in a column and format multiple cell values

Re: Macro to loop through cell values in a column and format multiple cell values

Re: Macro to loop through cell values in a column and format multiple cell values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions