I have files with loads of worksheets (about 100 each). When I enter data, it
is different for each sheet but I want to be in the same location on each
sheet. I start on my first sheet, locate the place I want to enter data and
enter the data into the cell. Now comes the problem - when I move to sheet 2,
I am in the active cell where I was last time I was in this sheet, not in the
same location as I have just left on sheet 1. I want to move from sheet to
sheet but stay in the same cell - can this be done? It was like this when I
used Lotus 123 but I can't seem to do it in Excel. Any help gratefully
received! BeanoKid