Macro help:Copy Value of cell on Sheet1, find value of the neighboring cell, paste wksht2

I could really use some help with a code to do the following:

Workbook contains 2 worksheets: "table" "list"

on worksheet "list" :
column A= Name
Column B = Start Date
Column C = City
Column D = State
Column E = Status
Column F = Event

On worksheet "table":
column A= Name
Column B = Start Date
Column C = City
Column D = State
Column E = Cost
Column F = Status

I need code to look in worksheet "list" column F,
If cell contains "Changed" then copy value of cell in column E (right next to it)
Then find the cell in worksheet "table" column A that matches worksheet "list" column A and
past value from column E from worksheet "list" in column F of worksheet "table"

i dont want formulas in the cell, so i want vba to do it instead of formulas.

Macro.jpg


Any help or suggestions would be GREATLY appreciated!! thanks

Sure, thanks for taking a crack at it!