Macro start cell is static

[debraj_patra1]

Hi all,

1. Source sheet is Input sheet & Employee master.
2. Destination sheet is FL master.

I have recorded a macro name “Accrual”, but the issues with I am stuck are,

1. Macro is not starting from the next to end row of destination or whichever cell we want.
2. Data set in source system changes every time, so how to deal with that.

https://www.dropbox.com/s/0tws973ntf0jcyq/Sample.xlsm?dl=0

 

[Caleeco]

Hello,

I couldn't follow the recorded macro all that well, can you please state in words what data needs copying between each sheet? You will have to use dynamic ranges as shown below:

Sub Accrual()
    Dim wsInput As Worksheet, wsFL As Worksheet
    
    Set wsInput = Sheets("Input sheet")
    Set wsFL = Sheets("FL Master")
    
    wsInput.Range("A2:F" & wsInput.Range("A" & Rows.Count).End(xlUp).Row).Copy
    wsFL.Range("B" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteAll
End Sub

Thanks
Caleeco

 

[debraj_patra1]

i want to copy the yellow highlighted cells in the Input sheets to FL master, but the issue i am facing is the Macro starts from the static cell where the macro was recorded.

 

[Dryver14]

When you recorded the macro did you click on use relative references first