Vba code to split multiple project in different cell in same column.

**UPA** · 08-01-2018, 03:52 AM

Hi All,

In column c I have client name and in column E I have Project Name. In project name column in cells there are multiple projects and some time some numbers I want multiple project split in different cell in column E and numbers in column F with this same client name. The output, which I require is shown in sheet2.

Please find the attached sample file.

**jindon** · 08-01-2018, 04:24 AM

Please Login or Register  to view this content.

**kersplash** · 08-01-2018, 04:25 AM

Here is a Power Query solution.

**UPA** · 08-02-2018, 01:07 AM

Hi Jindon,

The code which you provided me work like a charm.

Perfect!!!! Thanks so much for your assistance.

Vba code to split multiple project in different cell in same column.

LinkBack

Thread Tools

Rate This Thread

Display

Vba code to split multiple project in different cell in same column.

Re: Vba code to split multiple project in different cell in same column.

Re: Vba code to split multiple project in different cell in same column.

Re: Vba code to split multiple project in different cell in same column.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need VBA code to match the value and split the data in the multiple sheets based on column

Need Macro code to split data split in 7 sheets based on variable rows in column A

Split into Multiple sheets based on beginning string in a set column - Code help

[SOLVED] Function that concatenates multiple sub-project descriptions based on project code

Split cell data into multiple new rows and copy other column values

Want to split the data in single cell to multiple column

Bookmarks

Bookmarks

Posting Permissions