Need to paste the data from one sheet to another using vba

[A9kurs]

Hi everyone ,

I am trying to paste the data from one sheet to another using vba. I want to paste company "ALL" from Mannual savings sheet to FY data sheet in last cell where data is ending Cell "B26". using vba Highlighted in yellow which is a desired output required in end of FY data.

Thanks for helping

[Marc L]

Reproducing what any Excel beginner can achieve operating manually just starting with the Macro Recorder
so according to your attachment as a VBA beginner starter :

Sub Demo1() 
         Const C = "All" 
    With Sheets(1).UsedRange.Columns(1) 
         If IsError(Application.Match(C, .Cells, 0)) Then Beep: Exit Sub 
         Application.ScreenUpdating = False 
         If .Parent.FilterMode Then .Parent.ShowAllData 
        .Cells(1).AutoFilter 1, C 
        .Offset(1).Copy Sheets(2).Cells(Rows.Count, 2).End(xlUp)(2) 
        .Cells(1).AutoFilter 1 
    End With 
         Application.ScreenUpdating = True 
End Sub  

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄