"Sue" wrote:

I have a worksheet that includes data on medical resident students. Each
student will rotate through 12 different departments in a year. Is there away
to create a macro that will automatically shift the departments for each
month so that the cell data shifts down one cell and to the right one cell?
The last cell in a row would need to move to the first cell in the next column. Example:

Doctor Jan Feb Mar Apr May June
Smith IM Ortho Peds Neuro OB Surgery
Thomas Surgery IM Ortho Peds Neuro OB

Sorry - I was not finished sending my example. Thank you for your help.