Date stamp

[Dunncsu]

Hi guys new to the forum but i have been reading a ton in the last few weeks.

I have a workbook that has 3 tabs on it. This workbook is how people receive their work for the day. Sheet one is where the new work is placed it has data in columns A-M. In column M is a drop down menu.

I have already built a Macro (thanks to the help i found on this forum) that automatically moves all the information in a particular row when "done" is selected from the corresponding drop down menu.

So if "done" is selected from the drop down menu in cell M1 all of row 1 is moved to sheet three.

My problem is i want to have a time stamp on the row on column Q when it is moved to sheet 3.

Unfortunately the codes i have tried have not worked and they are all at work so i cant post them.

Can anyone help me out with this. I would classify myself as a beginner and i am trying to teach myself VBA. i am getting the hang of it pretty quick but this one has got me stumped.

I did find a single line code that worked but it drastically slowed down my "done" macro. This cant happen because the people using the spread sheet do not know Excel very well and when i tested it out on someone they started to freak out and get frustrated.

So to summarize, when row 1 A-M is cut and pasted from sheet 1 to sheet 3 (first row available) i want a time stamp in column Q of the row the info was pasted into.

Thank you for any help you can give.

[JBeaucaire]

I imagine there is a line of code in your macro that does the actual cut/paste. Just prior to that, you need to insert the datestamp, something along the lines of:

Please Login or Register  to view this content.

If you want to post up the code you're using, we can offer something more exact.

[Dunncsu]

I imagine there is a line of code in your macro that does the actual cut/paste. Just prior to that, you need to insert the datestamp, something along the lines of:

Please Login or Register  to view this content.

If you want to post up the code you're using, we can offer something more exact.

You know what i never even thought to add the date stamp to the macro i already have.
I was trying to write a entire new code.

Like i said i am a bit of a beginner trying to teach myself VBA.

I do have a line in the code that cuts and paste's i will try your suggestion tomorrow.

Thank you very much for the help.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[Dunncsu]

Ok i tried what was sugested above but now my macro instead of moving over the one row just keeps running the macro until every line of text has been moved to tab 3.

I only want text moved if the user picks "done"

Please Login or Register  to view this content.

[JBeaucaire]

Try this instead:

Please Login or Register  to view this content.

Please edit your post above and put [code] tags around your code, like I've done to mine in this post.

[Dunncsu]

Its giving me a Runtime error "type mismatch"

for this line

Please Login or Register  to view this content.

Thank you so much for your help with this

[JBeaucaire]

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook. Let's take a look at the same thing.