Transferring data between sheets
Closed
n_sheikh
Posts
1
Registration date
Wednesday November 23, 2016
Status
Member
Last seen
November 23, 2016
-
Nov 23, 2016 at 06:50 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 28, 2016 at 11:55 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 28, 2016 at 11:55 AM
Related:
- Transferring data between sheets
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Sheets right to left - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Data transmission cable - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 28, 2016 at 11:55 AM
Nov 28, 2016 at 11:55 AM
Hi n_sheikh,
The "Y" behind Will Klein in the result table is a typo, right?
See if the following code does as requested:
Best regards,
Trowa
The "Y" behind Will Klein in the result table is a typo, right?
See if the following code does as requested:
Sub RunMe() Sheets("Sheet2").Select Columns("A:A").Insert Range("A1").Value = "ID" Sheets("Sheet1").Select For Each cell In Range("B2:B" & Range("B" & Rows.Count).End(xlUp).Row) x = 2 Do If cell.Value & cell.Offset(0, 1).Value = _ Sheets("Sheet2").Range("B" & x).Value & _ Sheets("Sheet2").Range("C" & x).Value Then Sheets("Sheet2").Range("A" & x).Value = cell.Offset(0, -1).Value GoTo NextCell End If x = x + 1 Loop Until Sheets("Sheet2").Range("B" & x).Value = vbNullString NextCell: Next cell End Sub
Best regards,
Trowa