macro_man
10-05-2010, 08:52 AM
I would like a macro that will shift a section of data along with the cursor to the top of the screen.
I have many spreadsheets where I scroll down lists or enter numbers. When the cursor reaches the bottom I like to reposition the range so that the cursor is at the top of the screen with the data shifted upward as well. This way I can see ahead in the list and anticipate the length, style, etc. of the list. Currently, I must use the down-arrow until the data is moved upward, then use the up-arrow until the cursor is returned to the next empty cell in the list.
Is there a macro that can accomplish this?
Let me know if I need to clarify further.
I have many spreadsheets where I scroll down lists or enter numbers. When the cursor reaches the bottom I like to reposition the range so that the cursor is at the top of the screen with the data shifted upward as well. This way I can see ahead in the list and anticipate the length, style, etc. of the list. Currently, I must use the down-arrow until the data is moved upward, then use the up-arrow until the cursor is returned to the next empty cell in the list.
Is there a macro that can accomplish this?
Let me know if I need to clarify further.