It will be a little hard for people here to recommend anything to you
without knowing what data you are talking about and how that data is
supposed to look (examples would be useful) and what columns and/or rows
(depending on your layout) that data goes in.

--
Rick (MVP - Excel)


"Joe" wrote in message
...
OK, we have a spreadsheeet that we're simply using to log data on a job
shop floor, but the people doing the data entry are having a tough time
with consistency. I'd like to make a macro or something that allows them
to
type in the data and click a submit button.

If the data is correctly entered it simply adds the data to the end of the
spreadsheet, either at the top or bottom, whatever.

I'd also love to be able to break up the data into seperate files, like
each week a different file or sheet is used.

Time and day stamps would be applied so we know when the data was entered.

I'd also take recommendations for different apps, but this is just a log,
nothing fancy.

Oh, running Excel 2000 in the shop, but could upgrade to 2007 if worth the
time.

Thanks in advance,

--
Joe