Using Macros for Data Entry?
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 |
Using Macros for Data Entry?
Hi Joe,
Create a Userform it's easy see Debra web page she has an excelent step by step http://contextures.com/xlUserForm01.html If this was helpful please say yes "Joe" wrote: 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 |
Using Macros for Data Entry?
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 |
Using Macros for Data Entry?
?B?RWR1YXJkbw==?= wrote in
: Hi Joe, Create a Userform it's easy see Debra web page she has an excelent step by step http://contextures.com/xlUserForm01.html If this was helpful please say yes "Joe" wrote: 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. Oh, running Excel 2000 in the shop, but could upgrade to 2007 if worth the time. Just about to leave for the weekend (SantaCon HO! (Ho! Ho!)), will check this out on Monday, thanks my man. -- Joe |
Using Macros for Data Entry?
"Rick Rothstein" wrote in
: 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. date tool crimp size operator 12/12/2008 HT A-001 0.0386 Joe Like I said, simple, the tools are listed in another spreadsheet so populating fields with other data from other sources would be nice. I'm gonna try the Userdata tutorial on Monday. I suspect I've used it before, if it doesn't work I'll come back Rick. I'm not looking for specifics, I just want suggestions for an easy way to collect data, check the data for basic errors so it all looks the same, and add it to the end of a spreadsheet/log Doesn't have to be specific, I can figure that out on my own. -- Joe |
All times are GMT +1. The time now is 02:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com