Hello all,

I am really new to VBA and could use some help on a task i'm working on:

I am trying to code a sheet where if the value entered starts with a "W" it cuts it and moves it to the second-to-next blank column in row 1. I am using a scanner that scans bar codes and immediately presses return when scanned. When I scan codes that start with a "w" I essentially want to start a new column:
sample workbook.jpg

If That W# already exists I want to then move down to the next blank cell in the row that the W# is the header for and make that the new active cell to be able to scan under:
sample workbook2.jpg

Any help would be appreciated, let me know if you need more info.

thank you