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:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

@ BigBas

Perfect, woking like a charm

Thank you so much.

Reputation Added

Thank you, and glad it helped