Move cell if reference numbers partial match

[Looby757]

I pull an excel report daily (highlighted) and paste to an existing master sheet. I match column F reference numbers to column A, and move the debit to the matched row. This is exhausting for 100's of lines daily manually. Is there a way I can automate this process?

(Column A will always start with xxx* and column F new daily reports always start with XXX if that matters)

 

[Fluff]

This is a duplicate of https://www.mrexcel.com/forum/excel...alue-if-partial-string-match.html#post4987339

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.