Hi Paul and offthelip,

Thank you so much for your help! Some of the codes provided were very useful in pointing me to the right path! And sorry for the delay in reply, I got caught up in other projects.

Anyway I have managed to solve the codes and will leave it here in case someone else might find it helpful in the future 

Sub TransferData3()


    Dim i As Long
    Dim j As Long
    
    Dim firstrow1 As Long
    Dim firstrow2 As Integer
    Dim lastrow1 As Long
    Dim lastrow2 As Integer
    
    Dim branchname As String
    
    
    firstrow1 = Application.InputBox("Please enter the first row")
    lastrow1 = Application.InputBox("Please enter the last row")
    firstrow2 = Application.InputBox("Please enter the row to paste data")
    column1 = Application.InputBox("Please enter the column to copy data from, column:")
    column2 = Application.InputBox("to column:")
    column3 = Application.InputBox("Where to paste data:")
    column4 = Application.InputBox("Where to paste data.")
    
    For i = firstrow1 To lastrow1
    
        branchname = Sheets("NTB").Cells(i, "A").Value
        
        Sheets("Paste").Activate
        
        lastrow2 = firstrow2 + 49
        
            For j = 2 To lastrow2
        
            If Sheets("Paste").Cells(j, "A").Value = branchname Then
        
            Sheets("NTB").Activate
            Sheets("NTB").Range(Cells(i, column1), Cells(i, column2)).Copy
        
            Sheets("Paste").Activate
            Sheets("Paste").Range(Cells(j, column3), Cells(j, column4)).Select
        
            ActiveSheet.PasteSpecial (xlPasteValuesAndNumberFormats)
        
            End If
        
            Next j
        
            Application.CutCopyMode = False
        
        Next i
        
        Sheets("NTB").Activate
        Sheets("NTB").Range("A1").Select


End Sub
It isn't perfect and I would suggest using a userform instead to make things neater but I changed my project direction and decided to use a pivot table instead so I didn't bother making one.

Cheers!