So, is your first question wanting to link the serial number to extra information, like make a table with every serial number, and insert say, make, and model when its scanned?
Secondly, you can write a macro that pops up a userform, where it can be more accessible for employees scanning bulk items at once.
Thirdly, are the users using the same computer?? Because if they are individually logging in to each computer, you can use an
variable, which whenever a cell is changed, say B3 in this example, the locked cell, D3 will input the windows username the user is currently logged in under. Wrap that with an
and you'll have a functioning worksheet change.
Also, is there so much data you have to use two separate sheets?
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks