How to jump to a different cell

**singlec2** · 10-28-2012, 11:44 AM

Hello,

I'm trying to have data entered into a column, say E, and once a certain text is entered than have the active cell goto A in the following row. I would like have this macro run constantly as there will be alot of entries before it needs to change. I'd also like to have it always run so if someone entering data forgets to run the macro it won't mess up the data. There will be multiple individuals using this worksheet and some are less experienced with computers than others. I'm not even sure if this is possible, but if it is any help would be appreciated. Thank you for your time and assistance.

**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.