Ok, here's my deal .. I run a warehouse for a cable company, and I'm trying to make a smarter spreadsheet to handle equipment tracking. Every morning, we give out equipment to the techs to go install, and we scan the serial numbers into a spreadsheet using a Symbol UPC scanner.

Here's what I need it to do: We have six types of equipment going out, so I want my sheet to start with 12 rows, six of them being column headers for the six equipment types and a blank row in between each. Say I'm issuing out a cable modem, I need to click on the blank row beneath the modems header and scan the serial number. What I need the sheet to do is automatically insert a new blank row beneath the current row and position the cursor into that row in the same column so I can scan the next number. Then, once I've scanned all I need to for that particular piece of equipment, I can move down to the next header and repeat the process.

Any insight? Should I use VBA code or Macros?