Data Entry down a colum

spriesand - Sep 3, 2008 at 10:47 AM
 Bamidele - Jan 2, 2010 at 07:19 AM
I am trying to do some basic data entry using a scanner. I need to scan in over a thousand indiviudal components and I want to simply work straight down a colum. What I'm looking for is something that will automatically move to the next cell down after I scan in a barcode (typically letters and numbers). Can someone help me with a macro that will do this.

I think the logic is if the cell equals >1 character move to the next cell down. But I don't know how to write that.

Any help?



1 response

Maybe you should visit