need Outlook Macro to copy ranges from email attachment to local excel file in C drive

Team,

I have the below codes which I copied from google and edited a bit. but not working as per my requirement.

the objective is to :

identify an email in inbox with a specific subject line "Ageing Report" --> copy the ranges in that report from cell A2 to till end of the row which contains data --> paste it in the cell "A6" onwards in the specific local file "C:\Users\dlatha\Desktop\Collate.xlsx" --> and delete all the cells which are not relevant (for example : after copying data copied till row 565 the macro should delete/clear contents from row 566 onwards)

As said I copied the below codes from google and bit confused where to edit and what to edit to suit my requirement.

Kindly help.

Please Login or Register  to view this content.

Can you supply a sample of the workbook and an email? Also, where does the code breakdown or what does it do that it shouldn't or not do that it should?