delete respective row and paste to sheet2 after Autoemail action

**KK1234** · 03-21-2014, 05:24 PM

Hi all,
I have sheet1 where there is data table.
Sheet2 is intended to be storing actioned data

In sheet1 module I have following code which works fine and does following:
As soon as comments are typed in column 'N'
- It changes respective row colour to RED ( Cond Form)
-In column 'P' it counts the contents in column 'N' ( Counta formula)
- It then populates application username in column 'Q'
-It populates current date & time in column 'R'

When command button is pressed it dose the following:
- copied data from respective row and displays it in outlook
This allows to send email with appropriate data.

all works fine.

I want to achieve the following:
After email is sent, I want respective row to be deleted and pasted as value in sheet2 in next row free.
( I am getting issues here and not been able to do it correctly) Need help here.

Code is

Please Login or Register  to view this content.

Please help. I have attached trial sheet
Kind regards

**KK1234** · 03-21-2014, 07:36 PM

Hi all,
I am trying to incorporate code which copies to sheet2 , but column 'N' is blank and row it is not deleted from sheet1.
Almost there.
This one in module 1

Please Login or Register  to view this content.

And I call it as follows:

Please Login or Register  to view this content.

Need Help please.

Kind regards

**KK1234** · 03-22-2014, 03:34 AM

Hi all,
I have tried differently and it works with slight issue:
In column current date is populated by the main code... No issues at all.
I have created change event

Please Login or Register  to view this content.

It does cut and paste the said row, but also cuts few others above this row.
Really not understood.

There is something that I am missing.
Please help
Kind regards