Move cursor to the right automatically after data is entered/selected from the drop downs

Hi Everyone,

I have a sheet with a mixture of drop down lists and vlookups (to self populate some cells - left to right based on selection) and a few VBA codes in the background that adds a date and time entry when data is entered in specific cells and so, again to self populate the sheet with information.

My question is this

I would like a VBA code that will move the cursor to the next available empty cell to the right in the same row which is activated when either data is selected from the drop down lists or when data is entered manually. Where there's data already entered (already populated by vlookups for example) I want the cursor to move to the next available empty cell. This is not to exceed beyond column O (columns P,Q,R are hidden). Once the cursor reaches column O and see's there's data in it I want the cursor to start again from column B on a new row. Makes sense?

The workbook has already a portion of data in it, all of which the cells are full (no blanks)

In terms of cursor movement - I know the easiest method is to change the Excel Advance settings for the workbook. This works fine if you were entering data manually however, I have multiple drop down lists for user to select from. Therefore this method doesn't work for me.

Hi Dave,

I'm a bit of a simpleton

To repeat along to the next columns do I simply just change the Column No and Offset ? for example

Please Login or Register  to view this content.

Thanks

Slosh :-)

Thanks Dave

I cracked it !!!! - process of elimination

Please Login or Register  to view this content.

Thanks for the steer !!!

Much appreciated

Slosh :-)