Thread
:
I want to scroll up for new cells, not down
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
I want to scroll up for new cells, not down
How about a nice worksheet_change macro that when the last cell on the
current row is filled in auto inserts a row ready for the next entry?
--
Don Guillett
SalesAid Software
"Catacalycticoo" wrote in message
...
In Excel, the new blank rows appear at the bottom of the worksheet, but
this
isn't convenient to me because I am using the program for a daily log of
incoming inventory. I've figured out how to lock the top row of cells so
that
my column headings are visible as I scroll down, but what I really prefer
to
do is have my earliest entries be the bottom of the list and my most
recent
at the top without having to insert rows at top all the time. Is there a
way
to alter a worksheet so that the infinite field is at the top and not the
bottom of the worksheet? Can I keep my column headings locked so that they
consistently appear at the top despite this direction change?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett