Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert rows depending on entry in certain column
Columns F and P on my sheet contain data as below. What I need to do is
check each cell and decide if it has more than one 'entry', if it does then insert a row beneath (for 2 entries insert 1 row, for 3 entries insert 2 rows, etc, etc). 'entries' are separated by a comma. Column F Column P DD1 GF2,JK4 GH,BN HJ9 DR5,UU8 HK9 CV5,FG6 TY9 What I need to do then, if its possible, is to put the second/third/fourth 'entry' into the newly inserted rows (obviously without the comma's). I had thought of using texttocolumns to sort out the date but wondered if there was an easier way. TIA Gareth |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert rows depending on entry in certain column
What version of excel?
Come up with anything yet? -- Regards, Tom Ogilvy Gareth wrote in message ... Columns F and P on my sheet contain data as below. What I need to do is check each cell and decide if it has more than one 'entry', if it does then insert a row beneath (for 2 entries insert 1 row, for 3 entries insert 2 rows, etc, etc). 'entries' are separated by a comma. Column F Column P DD1 GF2,JK4 GH,BN HJ9 DR5,UU8 HK9 CV5,FG6 TY9 What I need to do then, if its possible, is to put the second/third/fourth 'entry' into the newly inserted rows (obviously without the comma's). I had thought of using texttocolumns to sort out the date but wondered if there was an easier way. TIA Gareth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count/Sum rows of a column depending on criteria from drop-down li | Excel Worksheet Functions | |||
Auto copy data rows between sheets depending on date entry | New Users to Excel | |||
A way to auto insert at top of each column with each entry? | Excel Discussion (Misc queries) | |||
Merge Rows depending on value of the first column | Excel Worksheet Functions | |||
Inserting # of rows depending on value in Column | Excel Programming |