Results 1 to 1 of 1

VBA help to search 3 IDs and to move List Box info to another sheet

Threaded View

Rick23 VBA help to search 3 IDs and... 11-13-2014, 03:58 PM
  1. #1
    Registered User
    Join Date
    09-08-2014
    Location
    US
    MS-Off Ver
    2010
    Posts
    38

    VBA help to search 3 IDs and to move List Box info to another sheet

    Hello,

    I am working on a project that I think my expertise has ran out.

    When the workbook is opened, the user will input their first name in A2. Then they will enter in the ID/IDs in B6-B8 for their work assignments for the day. Some users have been assigned 1 ID, some 2, some have 3. Once they input their ID/IDs they push the pink search button.

    Once this is pushed, it brings up a listbox of all their work assignment in the "items to work" listbox. once they work one of the files they will push the "done" button and that file will go away and be placed in the DONE tab. If they have to wait on something, they will push the "move to reviews" button and it will populate in the reviews listbox to work at a later time. Once they finish that file in the reviews listbox they will click the "done" button below the reivew listbox and it will be moved to the DONE tab.

    I was wondering if somebody could help me where I left off. I need help with...

    - I am able to get 1 ID to search for, but would like a code to search multiple IDs, up to 3 which would be in B6-B8
    - If the user cannot complete the file right away, they can push the "move to Reviews" button and the file will disappear from the "Items to work" section and be placed in the "reviews" section.
    - Once the user is finished with a file in the "items to work" section, they will click "done" and the file will disappear in the list box and the row in the MAIN FEED Tab, where the data came from, will be moved/deleted to the DONE Tab. Also, the row in the MAIN FEED Tab where the info was moved will be deleted. Everytime a file is moved to the DONE Tab, the next file will just go to the next blank cell. The info that needs to be moved to the DONE tab is listed in the DONE tab. Column A is the first name of the user which is found on the main sheets tab in A2.
    - Same as above, the Done button in the Review section will do the same thing

    - Lastly, If possible could somebody look at my "search1" macro? Right now, I have it where it looks in B6 on the "Main Sheet" and matches it up with 2 columns A and B in the "Main Feed" tab. I would like it to only match B6-B8 to only column A in the "main feed" tab.

    Attached is my workbook

    Thank you so much in advance for the help. I have gotten a lot of great help on this site.

    Rick
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. automatically move info to another sheet?
    By welsh_decs in forum Excel General
    Replies: 12
    Last Post: 11-25-2013, 10:30 AM
  2. Replies: 2
    Last Post: 06-19-2013, 03:23 AM
  3. Replies: 1
    Last Post: 02-03-2013, 09:54 PM
  4. Move data with Certain info onto another Sheet
    By Giftie in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-04-2010, 11:54 AM
  5. search sheet to get info on another
    By jj33002 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-01-2006, 04:34 PM

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