Moving Information from 1 set to another based on an IF
Closed
JDI12
Posts
1
Registration date
Wednesday February 12, 2014
Status
Member
Last seen
February 12, 2014
-
Feb 12, 2014 at 12:39 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 17, 2014 at 11:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 17, 2014 at 11:03 AM
Related:
- Moving Information from 1 set to another based on an IF
- Fnaf 1 download pc - Download - Horror
- Gta 1 download - Download - Action and adventure
- Fnia 1 - Download - Adult games
- Tentacle locker 1 - Download - Adult games
- Igi 1 download - Download - Shooters
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 17, 2014 at 11:03 AM
Feb 17, 2014 at 11:03 AM
Hi JDI12,
Try this code:
To implement: Right-click Proposals' sheets tab and select View code. Paste the code in the big white field.
Best regards,
Trowa
Try this code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns("D:D")) Is Nothing Then Exit Sub 'Change D to match your Project# column
If Target.Cells.Count <> 1 Then Exit Sub
Rows(Target.Row).Cut Sheets("Projects").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
End Sub
To implement: Right-click Proposals' sheets tab and select View code. Paste the code in the big white field.
Best regards,
Trowa
