No, I meant record a macro when you do it manually. Then run the macro when you
need to sort your data.



StargateFan wrote:

On Mon, 21 Jun 2004 20:07:15 -0500, Dave Peterson
wrote:

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.

You mean after each and every time??!! Wow, no, that would not be a
good solution at all. What's needed is code that always keeps this
entry at row 26 so no fiddles. sigh

I'm sure there's something out there that would do the trick, it's
just whether or not the person who might know how to do this happens
to read this thread lol.

Thanks just the same. Appreciate it.

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