I have 2 sheets in a workbook 1 is Picking Logs with colons the ther is total minutes picked. I want to us vlookup to look at the total picking minutes sheet and find any place in columb B where the total is greater then 0 and return that total along with the EE's name to the electronic picking logs sheet in cells P50 and Q50. I have been trying with macro, but starting to think VLOOKup might be the way to go.
Picking log-Rev6.xlsm tipper.xlsm
I see two workbook with multiple sheets.
Could you specify which workbook to use and indicate on it your desired outcome.
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
you can use either workbook, but picking logs rev 6 is prob the best one. I am looking to look on the total minutes sheets and find techs that that greater than 0 minutes picked, and put those names and minutes total on the electronic picking log sheet strarting at P50 and Q50
Your sheets are protected.
password is hi
Should i stop working on this thread for you then - http://www.excelforum.com/excel-prog...nother-3.html?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
No Arlu I just messaged you yesterday I think a combination of these will work easiest. yours is not working, but I was able to take the names the populated in the wrong column of the electronic picking log and almost use look up to get the total minutes
Could you add 1 or two required outcome?
yes I would like V look up to look into sheet total minutes picked and find ee's with more then 0 minutes worked and return those ee's names in p50 and there totals in q50
You have got 4 shifts in Total Minutes.
Does the order matter or you need anyone above 0 hours?
Order does not matter, just anyone above 0
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks