Main AFRsParts Sheet From AFRsInput Sheet

Hello this is a VBA question please,


I would like the parts for each AFR# to be the same on the AFRsInput Sheet and the AFRsParts Sheet.

1) If parts are added on the AFRsInput Sheet columns O:Q then press 'Update Data' those parts will be added to the table in AFRsParts Sheet.

2) If parts are deleted from the AFRsInput Sheet columns O:Q the press 'Update Data' then those parts will be removed from the table in the AFRsParts Sheet.

Whatever AFR# is in cell F2 on the AFRsInput Sheet will be the same number in cell D4 and column N.

Thanks for the help,
FF