Hi Daisy,
I know exactly what you are talking about. I have had the exact same problem on my Micra. Unfortunately, it is the gearbox that has gone and it will need replacing. I have just finished replacing my gearbox (hence posting late) and whilst I had them both out, manually turning them...