I think I have confused the power users with the wording on my previous question. I was attempting to get my sheet to show the last letter entered in a row (there will only be "one letter" in any given cell at any time ) say from row A2: AA2 as follows,
ROW A2:AA2= A B C D E F G H I G K L M N O P Q U R S T V W X Y Z ANSWER IN AA2 WOULD = Z
ROW A2:AA25= A B C D E F G H I G ANSWER IN AA26 WOULD = G
and so on.
The purpose of the sheet is to keep track of the many updates to the many drawings in our office at a glance in one column without having to scroll through a large list that is 24 cells wide some being updated only twice (C) and others at update Y at times.
This message was edited by rmtaylor on 2002-04-12 14:20
This message was edited by rmtaylor on 2002-04-12 14:36
This message was edited by rmtaylor on 2002-04-12 14:38
ROW A2:AA2= A B C D E F G H I G K L M N O P Q U R S T V W X Y Z ANSWER IN AA2 WOULD = Z
ROW A2:AA25= A B C D E F G H I G ANSWER IN AA26 WOULD = G
and so on.
The purpose of the sheet is to keep track of the many updates to the many drawings in our office at a glance in one column without having to scroll through a large list that is 24 cells wide some being updated only twice (C) and others at update Y at times.
This message was edited by rmtaylor on 2002-04-12 14:20
This message was edited by rmtaylor on 2002-04-12 14:36
This message was edited by rmtaylor on 2002-04-12 14:38