invert data

[bearyogi]

I have a range of data that I want to invert (top to bottom, bottom to top). I don't think a sort will work for me because of the way the data comes in. I need to delete the last row but that row will very. So if I can bring it to the top then I can delete that row of data. I hope that makes sense and thanks in advance.

 

[bluedragon2]

To delete a row would require VBA and with VBA you can detect the last row.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[bearyogi]

I am writing this in VBA, but due to my lack of knowledge I don't know how to do this. I can paste the code if you know how to do it.

 

[bearyogi]

I found a way to do what I want. There was a column that I could sort that was constant that gave me the results I needed.

 

[bluedragon2]

There is a way to find the last row in VBA, but I can't remember it, maybe someone else can explain...

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...