Results 1 to 6 of 6

Data Entry Efficiency Help

Threaded View

  1. #1
    Registered User
    Join Date
    11-02-2013
    Location
    Davis
    MS-Off Ver
    Excel 2003, Excel 2013
    Posts
    7

    Data Entry Efficiency Help

    Hello, I'm looking for suggestions on improving navigation in large spreadsheets.

    I've got a table that looks something like this, except it has a couple hundred columns and rows
    NappingExample.png

    I'm entering in the 'descriptor' data, which is freely generated for each Judge (a 1 represents that the judge used the descriptor for that product). For example, Judge1 for Product 1 can say 'sweet', for Product 2 can say 'pineapple' and 'cherry'. As I enter the descriptor data for each judge, I am adding descriptor columns for new descriptors and placing 1's.

    My problem is that I have many judges, many products, and many descriptors, so as I enter data I spend more time scrolling to place a 1 under the descriptors they used than anything else. I have the top descriptor row frozen so that I can still see the descriptors and they are sorted alphabetically, but that only helps so much. Can anyone think of a way to make navigation easier for entering the data? I would love a way to be able to skip over to a particular descriptor or descriptor starting with a particular letter.

    Any suggestions would be appreciated,
    Thank you!!
    Last edited by clw496; 05-21-2015 at 08:08 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 02-04-2014, 12:36 AM
  2. Vba for move data & clear entry screen for entry new data..
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-27-2012, 09:19 PM
  3. Code efficiency: Import data (vlookup)
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-16-2011, 04:32 PM
  4. Replies: 4
    Last Post: 07-21-2010, 10:24 AM
  5. Looking for a way to increase data input efficiency
    By Freezerburn in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-16-2007, 03:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1