+ Reply to Thread
Results 1 to 2 of 2

Auto copy from drop down list to new worksheet

Hybrid View

allyc0820 Auto copy from drop down list... 01-25-2011, 08:08 PM
Leith Ross Re: Auto copy from drop down... 01-25-2011, 09:33 PM
  1. #1
    Registered User
    Join Date
    01-25-2011
    Location
    Hartford, CT
    MS-Off Ver
    Excel 2010
    Posts
    2

    Unhappy Auto copy from drop down list to new worksheet

    So here's what I need help with, I know someone out there can help me! This is what I'm working with.

    I have two worksheets, "B" and "C" that auto copy with a macros to a Master List, which is the first sheet of my workbook. The columns for these sheets match up. Column D is the Status column, with a drop down list. There are many options such as Funding, Comtract Out, Hold, Dead, and Lost. The only three I am worried about are the Hold, Dead and Lost Deals. I want to create three new sheets named respectively, so that when I choose hold, dead, or lost, they are auto-copyed into the right sheet, while being deleted from the original sheet they were on.

    I have tried adapting so manu codes and i cant get any to work, can anyone help me???

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Auto copy from drop down list to new worksheet

    Hello allyc0820,

    Welcome to the Forum!

    It would help to where these drop downs are located on the worksheet. Do you want to copy the entire row or just select information?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ Reply to Thread

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