Peter,
i have copied your hare count spreadsheet onto my membership spreadsheet. looks complicated but is not really. as i enter a 2009 members details First name Surname and press enter the 2009 membership sheet goes and looks at the 2008 sheet. if the member was a member in 2008 it transfers the details into it if not it returns N/A. it also goes to your hare runs sheet and gets the total runs to date. when you enter the First Name and Surname on your sheet your sheet will get the 2009 membersip number and hare name from the 2009 membership sheet.
let me know if you need some assistance
clive
i have copied your hare count spreadsheet onto my membership spreadsheet. looks complicated but is not really. as i enter a 2009 members details First name Surname and press enter the 2009 membership sheet goes and looks at the 2008 sheet. if the member was a member in 2008 it transfers the details into it if not it returns N/A. it also goes to your hare runs sheet and gets the total runs to date. when you enter the First Name and Surname on your sheet your sheet will get the 2009 membersip number and hare name from the 2009 membership sheet.
let me know if you need some assistance
clive