Multi-line excel cells into rows

**walimos** · 08-03-2012, 05:46 AM

Hi,

I have three columns which contain multi-line cells, i.e. text separated by ALT+ENTER. Lines of these cells are grouped with each other, i.e. line 1 in cell A2 match with line 1 in B2 and C2. Then I have columns from onwards which have info in the first line which is attributable to all lines in the specific row.

I now want to turn these multi-line cells from columns A to C to multiple rows and copy the data of columns D to onwards to every new row.

Hopefully my explanation was not too complicated.

-Valt

**walimos** · 08-03-2012, 05:48 AM

Previous data deleted.

**arlu1201** · 08-03-2012, 08:14 AM

Is this data attached in post 2 containing real information? It looks so. In that case, please remove it and attach a new file with dummy data.

**walimos** · 08-04-2012, 03:47 AM

Pls find dummy sheet and desired output sheet enclosed.

**jindon** · 08-04-2012, 04:55 AM

try

Please Login or Register  to view this content.

**mike7952** · 08-04-2012, 05:09 AM

This should work

Please Login or Register  to view this content.

**walimos** · 08-06-2012, 09:58 AM

jindon & mike7952,

Thank you for your help. I'm still very beginner with Macros. How do I have to adjust the equation/macro if I want to increase the number of rows and columns in my excel sheet. In my actual data set my data expands up to column CL (which of columns A to F have multi-line data) and up to row 11550, number of lines within one column being max 54.

I just try to understand what are the lines which I have to modify.

**mike7952** · 08-06-2012, 10:55 AM

Can you upload you workbook?

**walimos** · 08-06-2012, 11:09 AM

Pls find extract of it enclosed. Unfortunately the whole file is too big to be uploaded.

**jindon** · 08-06-2012, 11:22 AM

try this

Please Login or Register  to view this content.

**walimos** · 08-06-2012, 11:38 AM

Thnx Jindon,

It works perfectly with the extract file but gives error when I try to run it with the whole data. Any idea what could be the reason. Error message / bug seems to be in the last row of the code " Sheets("result").Cells(1).Resize(n, UBound(b, 2)).Value = b"

---------- Post added at 10:38 AM ---------- Previous post was at 10:35 AM ----------

'Run-time error '9': Subscript out of range' is the error code.

**jindon** · 08-06-2012, 11:42 AM

Originally Posted by walimos

'Run-time error '9': Subscript out of range' is the error code.

It seems the code doesn't find the sheet named "result"...

Do you actually see the added sheet named result?

**walimos** · 08-06-2012, 11:46 AM

Yes I do. But nothing in it.

**jindon** · 08-06-2012, 11:49 AM

Do you have actually have sheet named "ActiveSheet"?

**walimos** · 08-06-2012, 11:54 AM

No I didn't have it. It seemed to solve the problem and works like a champ now. Thank you for your help jindon. You saved my day.

**jindon** · 08-06-2012, 12:17 PM

OK, no problem.

Multi-line excel cells into rows

LinkBack

Thread Tools

Rate This Thread

Display

Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Re: Multi-line excel cells into rows

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions