Macro needed to fill down other cell base on condition

[martinez_pedro]

I have accounts that I need to compare to see if they exist on my system the account that has a listed date, exist on my system then if I can fill the dates in the accounts the match then I will be able to delete the other accounts that don’t have a date see attach file for more understanding
thankyou all for any help provided

[rylo]

Hi

This assumes that your data will be setup as it is in columns A:D in your example file, and will give you a result in columns A:D that matches your example file M:P

Please Login or Register  to view this content.

rylo

[martinez_pedro]

thank you rylo the code works perfectly