+ Reply to Thread
Results 1 to 1 of 1

simple macro to add new record, edit/ search and print record

Hybrid View

  1. #1
    Registered User
    Join Date
    11-19-2009
    Location
    CA
    MS-Off Ver
    Excel 2007
    Posts
    62

    simple macro to add new record, edit/ search and print record

    Hi there.

    Hope you could help me and lend some expertise in my dilemma.

    Was hoping to create a simple record keeper in excel, except that the list of records is quite enormous
    Enclosed is a sample recordtracker i am looking at

    1st worksheet is the primary page for user to add, edit/search and print record
    2nd worksheet is the database of all entries

    To do:
    1. enable to add new record through worksheet1 and save row in worksheet2
    2. enable to search and edit particular record. Search is by Last name
    3. Print the worksheet1 page without the action box

    appreciate the usual assistance.

    all he best.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Userform Edit Record and GoTo record Command Buttons
    By 139runner in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 04-30-2020, 12:54 AM
  2. Replies: 1
    Last Post: 11-16-2012, 09:25 AM
  3. Command Buttons for Viewing Record, Next Record and Previous Record
    By david1987 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2012, 06:30 AM
  4. Search (find) data record and edit in Excel
    By BME in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2009, 09:46 AM

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