GermanyKorea
New Member
- Joined
- Feb 24, 2009
- Messages
- 7
So I wrote this nice data entry and log spreadsheet w/ macros for my job. A few questions have cropped up during the testing of it.
1) The data that we want to sort the log sheet by comes in this format
1-08, 2-08, 3-08, 4-08,....,1-09,2-09,3-09 and so on. Now, the only thing I've managed to get excel to do is sort them as text or they get turned into dates. When sorted by text, it sorts by the number before the dash first. I need it to first sort by the number after the dash. Is there a quick way to do this? The sort command is in the VBA code.
2) When the coworker that was testing this did a save-as and changed the file's name for a second log, the data that he entered in the new one logged into the old one as well. Does anyone know how this could've happened and/or how to prevent it from happening?
Thank you much!
1) The data that we want to sort the log sheet by comes in this format
1-08, 2-08, 3-08, 4-08,....,1-09,2-09,3-09 and so on. Now, the only thing I've managed to get excel to do is sort them as text or they get turned into dates. When sorted by text, it sorts by the number before the dash first. I need it to first sort by the number after the dash. Is there a quick way to do this? The sort command is in the VBA code.
2) When the coworker that was testing this did a save-as and changed the file's name for a second log, the data that he entered in the new one logged into the old one as well. Does anyone know how this could've happened and/or how to prevent it from happening?
Thank you much!