How to jump to a different cell

**TMS** · 10-28-2012, 11:57 AM

In all honesty, I don't really understand what you are trying to do. That said, it sounds as though you need a Worksheet Change event monitoring column E for the "certain text". In a Worksheet Change event, the cell being changed is the "Target". So, you would test the "Target.Value" against the "certain text" and then use:

Cells(Target.Row+1, 1).Select

Regards, TMS

**HaHoBe** · 10-28-2012, 12:30 PM

Hi, singlec2,

why don´t you rely on a Table in Excel2007/2010 (list in Excel2003) for the entry?

Ciao,
Holger

**singlec2** · 10-28-2012, 02:16 PM

Thanks for the replies. Currently the data entered is for inventory. Column E is currently being used for serial numbers of equipment that is handed out. The data inputted is off a scanner but I don't think that matters. After so many serial numbers are entered I'd like for someone just to be able to scan a barcode that would carriage the active cell back to A column the next row down. This will allow them to scan other information into columns A-D and then scan serial numbers again. I have a macro that after data is entered into columns A-D it goes across and then when it gets to E it fills down. The only thing I can't seem to figure out is how after a keyword, say "Complete" is entered, to have it carriage back to A the next row. I am doing this on 2010 so I will look at a table, to be honest I'm not to familier with all of this and have been trying to learn and do as I go. Again thank you for your time, hopefully this clears up what I was trying to do.