T
Tsurphr
Ok, here's my deal .. I run a warehouse for a cable company, and I'
trying to make a smarter spreadsheet to handle equipment tracking.
Every morning, we give out equipment to the techs to go install, and w
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 colum
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 ro
beneath the modems header and scan the serial number. What I need th
sheet to do is automatically insert a new blank row beneath the curren
row and position the cursor into that row in the same column so I ca
scan the next number. Then, once I've scanned all I need to for tha
particular piece of equipment, I can move down to the next header an
repeat the process.
Any insight? Should I use VBA code or Macros
trying to make a smarter spreadsheet to handle equipment tracking.
Every morning, we give out equipment to the techs to go install, and w
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 colum
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 ro
beneath the modems header and scan the serial number. What I need th
sheet to do is automatically insert a new blank row beneath the curren
row and position the cursor into that row in the same column so I ca
scan the next number. Then, once I've scanned all I need to for tha
particular piece of equipment, I can move down to the next header an
repeat the process.
Any insight? Should I use VBA code or Macros