I apologize if this has been discussed but I have not been able to find anything that has helped me. I am not familiar with Excel VBA at all and I only have a very little bit of self taught VBA experience in Access. I have also tried this in many ways based on codes I have found online and none of them are working properly but I am sure that is my fault.
I have two excel sheets in the same workbook. The first one contains col. 1, 2 and 3; the second sheet contains col. 1, 2, and 3. I need for my employees to be able to fill out the first sheet (they are not tech savvy enough to go to a second sheet and flip between them) and have it search the second sheet.
Column 1 in both sheets contain a location (ex. Hallway, Room 2, Stairway), column 2 contains a fixture (ex. A, B, C, D) and Column 3 contains a quantity. Sheet 2 has the location and fixture already filled in, I need for the employees to enter the location, fixture and how many they worked with that day. When they enter this I am trying to write some code that will search for the matching location and fixture in sheet 2, when it finds the match it will add the quantity entered to the quantity column (3). I also need it to add to that column because if they go back to the same location with the same fixtures I need the quantities to combine.
I apologize that this is so in depth but I hope someone might be able to help. The only code I have gotten to partially work so far is below but the comparison didn't work properly and I definitely couldn't figure out how to add the quantity. You're help would be very much appreciated!!
Bookmarks