Yes, I have thought if exactly that, color coding, as well as adding a small grayed-out column for separation. I even deleted the scroll bar and set up the tab button to page across, which should work depending on resolution settings. I think resolution can be controlled by commonizing the tablets used for data entry. However, I am told there is a way to set it up for the scroll bar to advance 2 columns instead of the default 1. I'm puzzled. I don't give up easily but I'm throwing in the towel. Thanks anyway!!!
Quote:
Originally Posted by GS[_2_]
I have researched for 2 days but cannot locate a solution. I have a
spreadsheet where I have frozen the first 2 columns and the first two
rows. To the right are columns of data in pairs. 2 columns represent
1 day and data is entered across both columns. We are having trouble
with multiple users entering data across the wrong 2 columns and
splitting days. I want to be able to use the scroll bar and have the
spreadsheet advance 2 columns instead of the standard 1 to keep the
days in pairs. I am at a loss.
You can scroll left/right one screen at a time using PgUp/PgDn while
holding down the *Alt* key. (PgUp=left; PgDn=right)
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public. vb.general.discussion |