Hi,
I am trying to copy multiple (Non Continuous) cells from sheet1 and wants to arrange them in an order (in a single Row) and paste them in next available Row.
For example:
<tbody>
</tbody>
now i want to paste them in next sheet like:
<tbody>
</tbody>
And next time i need that the values should go to the next available empty Row automatically. Any idea how to do that??
I am trying to copy multiple (Non Continuous) cells from sheet1 and wants to arrange them in an order (in a single Row) and paste them in next available Row.
For example:
A | B | C | D | E | |
1 | |||||
2 | ABC | ||||
3 | DEF | XYZ | |||
4 | LEF | ||||
5 |
<tbody>
</tbody>
now i want to paste them in next sheet like:
A | B | C | D | E | |
1 | ABC | DEF | XYZ | LEF | |
2 | |||||
3 | |||||
4 | |||||
5 |
<tbody>
</tbody>
And next time i need that the values should go to the next available empty Row automatically. Any idea how to do that??