On Tue, 22 Jun 2004 18:51:26 -0500, Dave Peterson
wrote:

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

In the end, I did a nasty workaround that I can live with. I made a
separate sheet for this entry and printed it off by itself. Not
ideal, by any means, but I put it in a page protector behind the
current index so that it's a little easier to find.

I was hoping there would be a way to anchor it always at row #26 but a
macro just seemed to cumbersome. I don't like making things more
complicated than they need to be since my workbooks are full enough of
macros and such. This way was not elegant but it removes the problem
entry completely since there seemed no way to tell it to stay at row
26 without a macro to potentially gum up the works g.

Thanks!

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.