I am having a really difficult time getting my spreadsheet to work like I want it to. I have been posting for help on mrexcel.com, but when I saw that you could post attachments on this site, I thought I'd give it a shot.
The purpose of my spreadsheet is to time machine cycles in a non-sequential order. When I open the file, ctrl+n starts the macros - I enter the site information and then a UserForm opens with several options. I first enter a New Major Event (the clock start time) and then enter the time. I then enter another New Major Event for a 2 minute machine warm-up. Then I start timing the cycles. Unfortunately, the machine operators don't always operate in the same sequence, which is what is causing me the heartburn. The cycles could go like this: Push, Spread, Reverse, Out Reverse; or like this: Push, Spread, Out Forward, Reverse, Out Reverse.
My problems are this (and you'll see if you open the spreadsheet and run the macro):
1) Times are entered on two lines at a time. For instance, when I time the Push segment for the first time, a time is entered on two lines. When I record the time for the Push segment a second time, the time is overwritten from the first recording. This continues so that I only have two times - the first time that was recorded and the last time that was recorded.
2) I need the times to be entered in the first available row in the column, kind of. When I start timing a segment with Push (say in row 8), then the rest of the segment times also need to be recorded in row 8. Now let's say I skip a segment (Out Reverse) in row 9, so that cell is blank in row 9, and I don't skip it in the following. It now needs to be recorded in row 10, not the empty cell in row 9.
I think if those two problems are fixed, I'd be 100% good to go. I'm kind of on a time crunch to get this finished before I have to go back out on another production study, so any help that anyone could provide me is very much appreciated!
Thanks!!
Bookmarks