Maybe you can pick up Row 26, paste it in a temporary worksheet, then delete row
26, do your sort and then copy|paste that row back into row 26.

If you record a macro when you do it once, you'll get your code, too.



Bridget wrote:

I don't know what it would be called or if this can even be done, but I need
one entry in a spreadsheet to always be in row 26. The way I've gotten
around this is to have split the workbook up into sheets and I have this
entry at the top of the 2nd sheet. It's turning out to be a major pain as
I'm still getting earlier correspondence to log in that throws the first
sheet off and items must flow into the second sheet. All my other workbooks
have no difficulties as all the entries are on one spreadsheet and they sort
themselves. With this one, I need to sort and then manually shift the rows.
Since there is still an abundance of correspondence that our predecessors
didn't deal with, I foresee a major headache unless there's a way to code
this entry to "anchor" at row 26.

Is this possible? And, if so, how would one do this?

Thank you.

--

Dave Peterson