Hi everyone
I have a quite simple Excel sheet with two tabs in it (Sheet1 and Sheet2)
Sheet 2 contains numbers in row Q and hyperlinks in column T
Basically any time when there is a number "1" in row Q, macro should copy paste hyperlink from reflective row to A4 in Sheet1, call few macros and then move back to Sheet2 and proceeds to another row with number "1" in row Q
So far I came up with this but I am not sure how can I add copy-pasting from one sheet to another into loop
Will be grateful for any help!
I have a quite simple Excel sheet with two tabs in it (Sheet1 and Sheet2)
Sheet 2 contains numbers in row Q and hyperlinks in column T
Basically any time when there is a number "1" in row Q, macro should copy paste hyperlink from reflective row to A4 in Sheet1, call few macros and then move back to Sheet2 and proceeds to another row with number "1" in row Q
So far I came up with this but I am not sure how can I add copy-pasting from one sheet to another into loop
Code:
Sub ScrapingAllTransfermarkt()
Const START_ROW As Integer = 1
For I = START_ROW To Cells(Rows.Count, 1).End(xlUp).Row
If Cells(I, 17) = 1 Then
Call transfermarkthome
Call storeDataTransfermarktHome
Call TransfermarktHomeClean
End If
Sheets("Sheet2").Select
Next I
End If
Next I
End Sub
Will be grateful for any help!