Help Please : TIMESHEET PROBLEM SOLVING
Hello all,
I have attached two files to this one is a autotime report of 3 seperate members of staff who have scanned in and out of an hand scanning machine and the other is the timesheet which I would like to link the handscanning results into as im currently having to type each individual start and finish time in.
Id be more than grateful if anyone as any ideas on how I could achieve this without typing each out.
Thank you for any help.
I named the data (Hand scan test C2:Q4 "Data1"
Then in B14 of Timesheet
=IFERROR(INDEX('hand scan test.xlsx'!Data1, MATCH($A14, '[hand scan test.xlsx]Page 1'!$A$2:$A$4,0),MATCH($B$11,'[hand scan test.xlsx]Page 1'!$C$1:$Q$1,0)+IF(B$12="Out",1,0)),"")
You can copy and paste that into the other cells.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks