"VX#######", or ###.# , where # = a number.

The VX numbers are easy enough to deal with. I say find VX, text to columns, next. Now I need to deal with these random numbers the appear in rows between some of the VX numbers. I need to find these random numbers and drop them into a cell associated with the VX number below it.

I am thinking 'Find "VX", look one cell above, if that cell is <> "VX" then cut and paste to ColF of this VX row, if it is = to "VX" find next and do it again.'

I need it to run to the bottom of the page and stop when it finds no more VX numbers

Does this logic work? and if so, how do I write it?

Any help would be appreciated!