|
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- If Target.Row > 1 And Cells(1, Target.Column) = "书籍名称" Then
- If Target.Column = 17 Then
- y = Sheets("文学").Range("f65536").End(xlUp).Row + 1
- Target.Offset(0, -1).Resize(1, 5).Copy Sheets("文学").Cells(y, "f")
- Else
- x = Sheets("排版").Range("f65536").End(xlUp).Row + 1
- Target.Offset(0, -1).Resize(1, 5).Copy Sheets("排版").Cells(x, "f")
- End If
- End If
- End Sub
复制代码 |
评分
-
查看全部评分
|