Hi,
I need to create new rows in separate worksheet based on number ranges. I think i can explain better with an example:
Existing Table
<tbody>
</tbody>
Required Table
<tbody>
</tbody>
Thanks in advance!
Lux
I need to create new rows in separate worksheet based on number ranges. I think i can explain better with an example:
Existing Table
From | To | First Name | Middle Name | Last Name |
100 | 101 | A | B | C |
214 | 216 | X | Y | Z |
<tbody>
</tbody>
Required Table
100 | A | B | C |
101 | A | B | C |
214 | X | Y | Z |
215 | X | Y | Z |
216 | X | Y | Z |
<tbody>
</tbody>
Thanks in advance!
Lux