Hi everyone,

I'm actually struggling with excel in order to perform a certain command.

I have a very basic matrix consisting of rows and columns. What I'd like to do is to rearrange (changing the location of) the rows in the matrix based on a certain criteria.
What I'd like to accomplish is: If one value (cell) in an entire row of the matrix is higher than a certain value (a cut-off value) then the entire row should be copy/paste to another location in excel in order to gather all the rows with values higher than the specified value on one side and the rows with values lower than the specified value on the other side. It shouldn't affect the columns, only the rows should be switched.

Can someone help me with this? Maybe with a function or in VBA?

Thanks in advance!