sorting by row

Hi, I have many columns in excel that I need have the rows within each sorted. Values in column B have been duplicated in column E at but they aren't in the same row. I need to match the rows from column B and E such that each row in B has the corresponding cell from column E below it. I would...

Hello all, I may have jumped to conclusion. One final piece of the query. The code provided by JLGWhiz works perfectly fine but I needed to ask my question with even more specificity. And again, thanks for the reply, JLGWhiz. __CODE__ Sub t() Dim sh As Worksheet, i As Long Set sh =...

I have a list of numbers sorted in column L from largest to smallest. I want to insert a line when the numbers switch from positive to negative. My code right now is just inserting a row wherever the cell is when I run my macro, can you tell me what I'm doing wrong? Dim i As Long i = 3 Do...

How can I get rows that if their cells have a certain value, place that row at the bottom of the table. For example, if my table has a column labeled Employee but the value in the cell is unknown, then i want that row to be placed at the bottom of the table.

Hello All, I considered myself a particularly advanced Excel user, that is until now what should be such a simple issue to rectify, has stumped me. File can be downloaded here: http://www.jowdy.com/uploads/Kara/ExcelSortProblem.zip PROBLEM: When I go to sort column A & B's data using column...