Results 1 to 4 of 4

automatic update of table and sorting

Threaded View

  1. #1
    Registered User
    Join Date
    11-29-2010
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    15

    automatic update of table and sorting

    I set up data validation to have drop downs in my computer issues log spreadsheet. The information from the sheet, Service Tag No, is set for data validation, which gives the drop down in the Issues log sheet. I am trying to figure out how to update the service tag no sheet, column1, with the input from a user under sheet, Issueslog, Column1. Any ideas?

    After that, I will also need help on making the document automatically sort, immediately after the user inputs a new row. Having to go to data, then sort, can be a bit time consuming. I have attached what i have so far.

    THanks for any insight!
    Attached Files Attached Files

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