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
Bookmarks