So this is going to be a long one...
I have a 5-tab Excel spreadsheet that I am trying to make multi use. The first thing that happens with it is I receive product and it gets scanned in. There is a macro that checks the sheet and if it finds the barcode, it adds one to the Qty of each of the parts of the box [which are in hidden rows]. It also adds the appropriate number to the corresponding box on the third sheet. Right now, this all works properly. The last sheet is mainly what I need help on. I need it to add a row for each of the boxes that are checked in. So, if I scan 3 of Box A and 5 of Box B I need excel to pull the information and make 8 rows, one after the other, into EmployeeSheet. The info I need is; Barcode, Sku, Box Name. Then an employee will take the box and they select their name from the dropdown menu and a timestamp is recorded [this part works as well] THEN - once someone takes the box I need the qtydelta on sheet two to update accordingly.

I don't care if this is done through VLookups, Macros, or other formulas. Please keep in mind I don't have much experience with any of these things. I dabble in them here and there and with some guidance I am hoping all this is doable. Attached is a mock up worksheet with the above mentioned macros.

Thanks in advance!
~Sam

s_262HELP.xlsm