A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Anchoring" one row so that it always appear in one spot?



 
 
Thread Tools Display Modes
  #1  
Old June 21st, 2004, 08:59 PM
Bridget
external usenet poster
 
Posts: n/a
Default "Anchoring" one row so that it always appear in one spot?

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.


  #2  
Old June 22nd, 2004, 02:07 AM
Dave Peterson
external usenet poster
 
Posts: n/a
Default "Anchoring" one row so that it always appear in one spot?

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

  #3  
Old June 22nd, 2004, 07:56 AM
StargateFan
external usenet poster
 
Posts: n/a
Default "Anchoring" one row so that it always appear in one spot?

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.


  #4  
Old June 23rd, 2004, 12:51 AM
Dave Peterson
external usenet poster
 
Posts: n/a
Default "Anchoring" one row so that it always appear in one spot?

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

  #5  
Old June 23rd, 2004, 01:42 AM
StargateFan
external usenet poster
 
Posts: n/a
Default "Anchoring" one row so that it always appear in one spot?

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.


Phew, I misunderstood big time I think.

I'll have to go back and read your post carefully again. I'm learning
so much new stuff every day but there is still a lot I don't know or
that I don't understand easily. So much new stuff 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.


  #6  
Old June 25th, 2004, 01:46 AM
StargateFan
external usenet poster
 
Posts: n/a
Default "Anchoring" one row so that it always appear in one spot?

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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:46 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.