Automatic data transfer
Closed
sam
-
Jul 15, 2014 at 03:42 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 15, 2014 at 10:24 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 15, 2014 at 10:24 AM
Related:
- Automatic data transfer
- Free fire transfer - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Nvidia automatic driver detection tool - Guide
- Tmobile data check - Guide
- Gta 5 data download for pc - Download - Action and adventure
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jul 15, 2014 at 10:24 AM
Jul 15, 2014 at 10:24 AM
Hi Sam,
Right-click on the Materials sheet tab and click on "View code". Paste the following code in the big white field:
Once that is done, whenever you enter an "H" in column F of the Materials sheet, column A to C of that row will be copied to the first available row of the Hire sheet.
Best regards,
Trowa
Right-click on the Materials sheet tab and click on "View code". Paste the following code in the big white field:
Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Columns("F:F")) Is Nothing Then Exit Sub If Target.Value = "H" Then Range(Cells(Target.Row, "A"), Cells(Target.Row, "C")).Copy _ Sheets("Hire").Range("A" & Rows.Count).End(xlUp).Offset(1, 0) End Sub
Once that is done, whenever you enter an "H" in column F of the Materials sheet, column A to C of that row will be copied to the first available row of the Hire sheet.
Best regards,
Trowa