Range Intersects

[SDRBIRD]

I am trying to create a staff payroll spreadsheet, all is going well except one issue.

I need to do the following:
If name entered in range A8:A60 move to cell in range B8:B60. If user moves away from cell in range B8:B60 and name (text) exist in range A8:A60 message box please enter department.

Many thanks

 

[ajetrumpet]

I am trying to create a staff payroll spreadsheet, all is going well except one issue.

I need to do the following:
If name entered in range A8:A60 move to cell in range B8:B60. If user moves away from cell in range B8:B60 and name (text) exist in range A8:A60 message box please enter department.

Many thanks

try recording yourself a macro with the macro recorder for the the movement of the cells. you'll notice that is will use the CUT and PASTE properties of the range object in VBA. for the if statement, use the ISBLANK() function or the LEN() function to check if there is a length of the cell value greater than 0.

 

[SDRBIRD]

not sure I made it clear what I want to do.
If there is a name is any cell in column A the adjacent cell in column B can not be left blank, if user moves away from cell message box "please enter department".

When user enters name in cell A8 target cell becomes B8, if user moves away from cell B8 and cell left blank message box "please enter department", etc all the way down to cell A60.