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.