VBA copy down till the specific coulmn range

Hello friends

i want copy above cell value down to column up to range of column "A"

Please see attached workbook for further information

Thanks in advance

Vaibhav

vaibhav2312, I'm having trouble understanding what you want to do. I can see your attachment just fine, but have no way to decipher what the phrase below means:

copy above cell value down to column up to range of column "A"

Please advise.

Sir,

i simply want to copy above cell value in to column G H I, upto lastrow of column A

For example column G last cell contain data i.e. 6 then i want to do Autofill column G upto lastrow of column A

Does this work for you? Let me know if you need additional help

Sub FillSomeOfTheseValuesDowntoTheEndOfTheUsedRangeBro()
    Dim rRows As Long
    Dim lRows As Long
    Dim fSize As Long
    Const cols = 3
    
    lRows = Range("G" & Rows.Count).End(xlUp).Row
    rRows = ActiveSheet.UsedRange.Rows.Count
    fSize = rRows - lRows + 1
    
    Cells(lRows, 7).Resize(fSize, cols).FillDown
End Sub

@ BigBas

Perfect, woking like a charm

Thank you so much.

Reputation Added

Thank you, and glad it helped