Excel Help!!!
 

Hi All,

I am having an issue where i have designed a template to collect
information. when the enter button is pressed i wanted all the fields with
data to be tranfered to another sheet and the template cleared. i also want
the data to be placed along a row (ie cells c3,c4,c5 to correspond to a1, b1,
c1). Alot of users will be accessing the sheet and at the end i need to
review all data, so data will need to be place in the empty row (ie
increments down one row if row is not empty AND No datacan be over ridden)

PLEASE HELP!!!!!!