Results 1 to 3 of 3

macro button for database like sheet. Update & ReSort list alphabtzd

Threaded View

  1. #1
    Registered User
    Join Date
    01-14-2007
    Posts
    18

    macro button for database like sheet. Update & ReSort list alphabtzd

    How would one go about creating a spreadsheet that is as wide as column
    K, and will serve as a database. As each entry is added, the rep keying this will hit `add` button, and then the list will re adjust itself and align in alphabetical order Lastname, Firstname. I think this is a simple form, please see attachment. (Office 2003)

    I wanted to place the light grey row odds and evens conditional formatting rule in there(static background highlight). I forgot what the term was called.
    OH And one more thing, after they are added to the list below, I would like to have the below list locked in a manner in which no one can change it unless they have a password.
    (This will protect against unauthorized changes.)
    The attempt I made here, its unpredictable - I hit data and then forms,
    and sometimes it gives me a clean entry point, and sometimes it uses
    the actual data as form fields.. Please help!

    Thank you

    This is a certification list, and when each rep was certified(date) for 3 different certs.
    Attached Files Attached Files
    Last edited by DoraExplorExcel; 09-21-2007 at 09:12 AM.

Thread Information

Users Browsing this Thread

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

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