Hi,
I need a macro code to paste the values as below of last used rows by finding in given 6 columns.
For example:
Here banana columns used more rows so based on more used i need your support to paste apple columns values on below.
Please help me to get VBA code for below scenario.
<tbody>
</tbody>
<tbody>
</tbody>
I need a macro code to paste the values as below of last used rows by finding in given 6 columns.
For example:
Here banana columns used more rows so based on more used i need your support to paste apple columns values on below.
Please help me to get VBA code for below scenario.
apple | 16 | orange | 20 | banana | 28 | |
16 | 25 | 67 | ||||
17 | 23 | 78 | ||||
56 | 98 | |||||
87 | ||||||
Apple | 81 | orange | 87 | banana | 67 | |
<tbody>
</tbody>
apple | 16 | orange | 20 | banana | 28 | |
16 | 25 | 67 | ||||
17 | 23 | 78 | ||||
56 | 98 | |||||
87 |
<tbody>
</tbody>