Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract Informations inside a Borderframe
Dear Group,
I´v got a little Problem: In my Worksheet, there are one ore more Rows combined with a frame | A | B | C | D 1 +----------+-------+------+-------+ 2 |Monday |Over |19:00 |Start | 3 | |Time +------+-------+ 4 | | |20:00 |Break | 5 | | +------+-------+ 6 | | |21:00 |End | 7 +----------+-------+------+-------+ 8 |Tuesday |OFF | | | 9 +----------+-------+------+-------+ ... ... I need a possibility to extract the Information into the following Shape: Monday | Over Time | 19:00 | Start Monday | Over Time | 20:00 | Break Monday | Over Time | 21:00 | End Tuesday | Off | | My Idea : Find the upper Border LineStyle.. search the lower LineStyle, and Combine each Row to a Value. Paste Value in Each Row in this Range. My knwoledge of VB is not so good, and I need this solution only to extract a large Sheet automaticly. Any Ideas ? Thanks, Oliver |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract Informations inside a Borderframe
-----Original Message----- Dear Group, I´v got a little Problem: In my Worksheet, there are one ore more Rows combined with a frame | A | B | C | D 1 +----------+-------+------+-------+ 2 |Monday |Over |19:00 |Start | 3 | |Time +------+-------+ 4 | | |20:00 |Break | 5 | | +------+-------+ 6 | | |21:00 |End | 7 +----------+-------+------+-------+ 8 |Tuesday |OFF | | | 9 +----------+-------+------+-------+ ... ... I need a possibility to extract the Information into the following Shape: Monday | Over Time | 19:00 | Start Monday | Over Time | 20:00 | Break Monday | Over Time | 21:00 | End Tuesday | Off | | My Idea : Find the upper Border LineStyle.. search the lower LineStyle, and Combine each Row to a Value. Paste Value in Each Row in this Range. My knwoledge of VB is not so good, and I need this solution only to extract a large Sheet automaticly. Any Ideas ? Thanks, Oliver . You don't necessarily need VB to do this: Create another worksheet (I will call your original worksheet Sheet1 and the new one Sheet2). For each column where you want to "fill in the blanks" use a formula like this (with relative addresses) in cell A2 of Sheet2: =IF(IsBlank('Sheet1'!A2),A1,'Sheet1'!A2) {You are saying if the cell on the sheet you are examining is blank, continue repeating the last value found, otherwise copy the new value} Copy the formula into the entire column if needed, but then copy the first row of sheet1 into the first row of Sheet2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I extract characters from inside a cell? | Excel Worksheet Functions | |||
Importing CSV-File with formatting informations | Excel Worksheet Functions | |||
How do I extract 3 numbers inside a longer number to another column ? | Excel Discussion (Misc queries) | |||
informations search | Excel Discussion (Misc queries) | |||
Can't find informations on TrendLines | Excel Programming |