PivotIdiot
Board Regular
- Joined
- Jul 8, 2010
- Messages
- 76
- Office Version
- 365
- Platform
- Windows
Hi All,
I'd like to create a macro that runs on selected cells in a given row.
There are usually only 4 cells in that row with data.
The data within each cell is on separate 'lines' within each cell, eg:
I'd like the macro to separate the data in to individual rows, these rows must be inserted below as there are rows with viable data below, eg:
I've seen a couple of examples that i can work with but it'll take me an age to get it to work how i want and I know you people deal with vba all the time.
Can anyone help?
Massive thanks in advance
I'd like to create a macro that runs on selected cells in a given row.
There are usually only 4 cells in that row with data.
The data within each cell is on separate 'lines' within each cell, eg:
10 20 30 40 | A B C D | Bob John Harry Seb | Jane Sarah Daisy Emma |
I'd like the macro to separate the data in to individual rows, these rows must be inserted below as there are rows with viable data below, eg:
10 | A | Bob | Jane |
20 | B | John | Sarah |
30 | C | Harry | Daisy |
40 | D | Seb | Emma |
I've seen a couple of examples that i can work with but it'll take me an age to get it to work how i want and I know you people deal with vba all the time.
Can anyone help?
Massive thanks in advance