VBA code help. Using command box. Search/autofill/scan

Basically I am ok with excel but nothing like I am attempting to do this time.

I have several columns but this is open for review if you think of a better way to do it

The columns I have are as follows
ID: Unique number associated to a certain asset but there is duplicates
Location: If the ID is found it will automatically fill in a set value
Desk: If the ID is found it will automatically fill in a set value
Asset number: Using a barcode reader that automatially returns after scan (or manual entry)
Serial number: Using a barcode reader that automatially returns after scan (or manual entry)

I want to have a tool to take serial numbers (2 different ones) using a command button. When pressed it will populate for the ID. This will be entered manually and the Location and Desk will be filled in automatically. It will then prompt for the asset number which is scanned and entered into the relevent cell, then ask for the Serial number and again is scanned and entered into the relevent field.

If an ID is searched and the location or serial number etc is already populated (duplicate) then it adds the details to another tab called "Duplicates in store" which has all the same columns as the first tab.. Also the main tab is called "In store"

So I know I am asking a lot but if someone could help or wright this it would be greatly appreciated.

Hi mcghue,

Please change the thread title to reflect the query you are asking... see the forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html



Regards,
DILIPandey
<click on below * if this helps>

Hi mcghue,

click on Edit thread and then click on Go Advanced and then you can edit the thread title there.

Regards,
DILIPandey
<click on below * if this helps>

Thats great....

Please share the solution here as it may help other users... thanks.
also, mark this thread as [SOLVED]..



Regards,
DILIPandey
<click on below * if this helps>