| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy contents to another page
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 This code works fine but I need it to retain the contents on the "Parts Sent to Assembly" sheet when I delete the contents on the "Sent to Assembly" sheet. Any suggestions! Thanks in advance!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Send contents to another page | Excel Worksheet Functions | |||
| copy cell contents to different page | Excel Discussion (Misc queries) | |||
| Add contents page to workbook | Excel Discussion (Misc queries) | |||
| Contents Page | Excel Discussion (Misc queries) | |||
| Macro that copy page to page just some filled cells | Excel Discussion (Misc queries) | |||
Threaded Mode
