Tracking pcs, in and out in excel

So im trying to keep track of pcs that move from the floor (active and being used) to the warehouse (being worked on) i have 2 tabs setup in excel. and the bar codes scan in just fine.

is there a way to:

1. input extra info for the bar codes in a separate sheet and have that populate in once a unit is scanned.

2. move that unit from the warehouse tab to the floor tab or vise versa once scanned? (and any way to track what member scanned it?) other then trusting them to input their name.

I've looked into using programs but cant find a free one that just does in/out tracking. i don't need sales,reports or any of that extra stuff.Attachment 653943
Attachment 653944