Deleting and copy cells
 

I want to know is is possible to do the following and how.

1. Data entry person will be deleting a NAME on Sheet1 manually.
2.Macro will write the NAME that was deleting on Sheet1 to Sheet2 and will
write the date that was performed this action.

This is possible?

Deleting and copy cells
 

Do you mean clearing the cell with the NAME or actually deleting the cell and
pulling the rest of the column up?
--
Gary''s Student - gsnu200720


"anamarie30" wrote:

I want to know is is possible to do the following and how.

1. Data entry person will be deleting a NAME on Sheet1 manually.
2.Macro will write the NAME that was deleting on Sheet1 to Sheet2 and will
write the date that was performed this action.

This is possible?

Deleting and copy cells
 

Deleting the content of the cell (this will be perform manually) and then
with the macro automatically write the deleted data to another sheet.

"Gary''s Student" wrote:

Do you mean clearing the cell with the NAME or actually deleting the cell and
pulling the rest of the column up?
--
Gary''s Student - gsnu200720


"anamarie30" wrote:

I want to know is is possible to do the following and how.

1. Data entry person will be deleting a NAME on Sheet1 manually.
2.Macro will write the NAME that was deleting on Sheet1 to Sheet2 and will
write the date that was performed this action.

This is possible?

Deleting and copy cells
 

A worksheet_change event could undo the changecapture the changeask if
user really wanted to do itif so, do it copy the address,original,change
to a "tattle sheet"
--
Don Guillett
SalesAid Software

"anamarie30" wrote in message
...
I want to know is is possible to do the following and how.

1. Data entry person will be deleting a NAME on Sheet1 manually.
2.Macro will write the NAME that was deleting on Sheet1 to Sheet2 and will
write the date that was performed this action.

This is possible?