This is my example of a worksheet. How do I select non-sequential cells and copy them to a row on another sheet in the workbook to appear like the second table below?
<TBODY>
</TBODY>
<TBODY>
</TBODY>
6 | |||||
Charles | Jones | Invoice#8 | |||
123 Main St. | 5/2/2013 | ||||
Anytown | |||||
NJ |
<TBODY>
</TBODY>
6 | Invoice#8 | 5/2/2013 | Charles | Jones | 123 Main St. | Anytown | NJ |
<TBODY>
</TBODY>