Need to insert date and user when Event macro happend

[onbeillp111]

I have this code that is working perfectly. When any row in column 14 becomes "Closed" The entire row is cut and pasted into the "Closed" worksheet. What I am trying to figure out is how to make the date and user get inserted in column 15 and the corresponding row to the "Closed" event. Any help would be greatly appreciated.

Please Login or Register  to view this content.

[emilyloz]

Hi onbeillp111,

I'm fairly new myself. But I can help on one of your problems. I currently have a user enter "y" if something is completed. and then once a y is entered, it adds a time stamp to the column next to it:

Please Login or Register  to view this content.

[emilyloz]

Also,

I am using a macro to move rows from one sheet to another. This is kinda similar as in it looks for a "y" in column 7.

Please Login or Register  to view this content.

[onbeillp111]

The first code works like I need it too but I need to incorporate it into original code and when I tried it did not work. The date and time comes up but the row no longer transfers to the other sheet. I am also new to this and i tried to combine the two codes and came up with this.

Now when I select Close in column N, the date comes in the next column but the row is not transfered to the "Closed" sheet and deleted from the main sheet.

Please Login or Register  to view this content.

[emilyloz]

Hmm, maybe I was the wrong person to help, but I always find it more user friendly to have a button to move the rows to a different sheet. That way it reduces the amount of user input errors, and the user can determine when the rows are ready to be transferred.

Sorry! I tried.
here are the links where I received my help- maybe one of them can help you:
http://www.excelforum.com/excel-prog...82#post3258582

http://www.excelforum.com/excel-prog...47#post3261747

[emilyloz]

Perhaps try separating your if statements? just a guess.

[onbeillp111]

I appreciate your help. I used your first code and it works just like I need it too I just need to figure out how to combine the code that I have now and you date insertion code.

[onbeillp111]

I combined them, THANKS

[emilyloz]

Great! post your solution incase there are others who will benefit from it!

[onbeillp111]

Combining the two codes gave me this. When Column N goes Closed, the date is inserted in column O and the row is cut and pasted into the "Closed" worksheet.

Please Login or Register  to view this content.