Excel Update

[Robert Couchman]

Hello All,

It seems like ages since i was last here!

i have a new task ahead!

can anyone help?

i need to create a sheet that has a column (b) that has
names typed in,

each time a name is inputted into a cell it needs to copy
that name, the title (C,2), and the date (B,3),

it then needs to put them into a different sheet, in the
row after the last used, in the following order Name,
Course, Date.

can anyone please help?

sheet1 is the input sheet, and sheet2 is the output sheet!

thank you,

Robert Couchman

 

[Frank Kabel]

Hi Robert
why don't you use the Excel build-in feature:
'Data - Form'
or use
http://j-walk.com/ss/dataform/index.htm
directly on your output/storage sheet?