Have you considered a Data Form?

Try this:
A1: Surname
B1: Forename
C1: Year

Select A1:C1
DataForm
(Excel will give a warning...ignore it and click OK)

A data form will open.
[Tab] advances through fields
Pressing [Enter] goes to the next record

Something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Wibs" wrote:


Hi,

I am entering lots of family history data into a spreadsheet. At the
simplest I have columns (in cells A1 B1 C1) the headings, Surname,
Forename, Year. Right now, I enter in cells A2 B2 and C2 say: Smith
<Tab John <Tab 1555 <Enter, move mouse to the A column in the next
row down). What I want to happen is when I have entered the last data
in a row and pressed <Enter I move automatically to the A-column in
the next row down.

Is this possible?

Regards and a Merry Christmas to all

Wibs


--
Wibs
------------------------------------------------------------------------
Wibs's Profile: http://www.excelforum.com/member.php...o&userid=28922
View this thread: http://www.excelforum.com/showthread...hreadid=494464