Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Worksheets("Sent to Assembly").Range("a3:c100").EntireRow.Copy Destination:=Worksheets("Parts Sent to Assembly").Range("a3:c100") End Sub Can anyone help changing this code to what I need, please! I'm trying to somehow keep the contents of the "Parts Sent to Assembly" after the "Sent to Assembly" contents have been deleted. After the contents are deleted from the "Sent to Assembly" and New data is entered only the New data is copied to the "Parts Sent to Assembly. Is there a way to keep the contents of the "Parts Sent to Assembly" and the new data from the "Sent to Assembly" be added to the next blank row. I need to keep track of all the "Parts Sent to Assembly" but I do not need to keep track of the "Sent to Assembly" once it is deleted. Thanks so much in advance!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
difficult question | Excel Discussion (Misc queries) | |||
Difficult for me, probably basic to you | Excel Worksheet Functions | |||
Help, too difficult for me. | Excel Worksheet Functions | |||
Too difficult for me, please help. | Excel Worksheet Functions | |||
Difficult but do-able? | Excel Discussion (Misc queries) |