Hello to the VBA pros here,

Is it possible for VBA macro to do this?
I wish to highlight a section of cells and have it automatically select the lowest value out of each row, cut that cell and 1 cell to it's right and have it be inserted to the Z column.

It's basically a bunch of prices and vendor names listed to the right of the price and i want to take the lowest price and have it be cut and inserted (has to be the insert function instead of paste) to the Z column, just by highlighting the cells i want the macro to affect.

Example of my worksheet. I high-lite this entire thing and hit the macro.

|12.00|vendor A|22.00|vendor B|15.00|vendor C
| 5.00|vendor A| 7.00|vendor B| 8.00|vendor C
|45.00|Vendor A|45.00|Vendor B|40.00|Vendor C <------ (I have no idea how the macro will affect prices that are the same, maybe have it ignore same prices and i will pick manually)

Seems like quite a complicated macro. Appreciate it if any experts here can figure it out.