Results 1 to 10 of 10

Move data from one worksheet to another based on selection from a drop-down menu

Threaded View

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    Camden, NJ
    MS-Off Ver
    Excel 2007
    Posts
    9

    Move data from one worksheet to another based on selection from a drop-down menu

    I work in a counseling office, and we receive numerous phone calls from clients that we add to a shared spreadsheet until we can return their phone calls. The worksheet contains multiple rows that are added to regularly. One of the cells (Status) is a drop down, with options based on what transpires during the call. I would like the entire row of information cut and pasted to a different spreadsheet when an option is selected from the drop down list. For example, if the option selected is "appointment scheduled," the client's name and their information would be moved to the worksheet labled "appointment scheduled" in the next available row, and then no longer appear on the initial sheet. Is this possible, and if so, how would I do it? I have some familiarity with excel, but I'm not an expert so simple instructions would be helpful. I've attached a sample of our document to help with the process.
    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