| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Deleting embedded graphs during worksheet copy | Charts and Charting in Excel | |||
| Copy a record before deleting | Excel Programming | |||
| Copy a record before deleting | Excel Programming | |||
| deleting unused cells / getting rid of inactive cells | Excel Discussion (Misc queries) | |||
| Deleting Hyphens or Dashes from multiple cells without deleting the remaining content | Excel Programming | |||
Hybrid Mode
