Hello All,
I have data entered into a worksheet named "Calculations" (See Below). I require a macro to find the top two figures from Column V ( In this case V7 and V4) and copy (T7 and V7) and (T4 and V4) to the next empty row/s columns C and D in the table on my next worksheet named "Figures" . If possible I would like a "+" sign to be added
to the numbers when they are transferred saving me time in having to do it manually after each transfer.
Hope you can help. Thank you
<tbody>
</tbody>
I have data entered into a worksheet named "Calculations" (See Below). I require a macro to find the top two figures from Column V ( In this case V7 and V4) and copy (T7 and V7) and (T4 and V4) to the next empty row/s columns C and D in the table on my next worksheet named "Figures" . If possible I would like a "+" sign to be added
to the numbers when they are transferred saving me time in having to do it manually after each transfer.
Hope you can help. Thank you
| S | T | U | V |
| 3 | Roberts | 0.47 | -0.16 |
| 4 | Carletto | 0.26 | 0.16 |
| 5 | Carlisles | 0.42 | -0.11 |
| 6 | Harrisons | 0.3 | 0.01 |
| 7 | Robinson | 0.25 | 0.25 |
| 8 | Samuals | 0.44 | -0.13 |
| 9 | Smiths | 0.36 | -0.05 |
| 10 | Welks | 0.36 | -0.05 |
<tbody>
</tbody>
