Main AFRsParts Sheet From AFRsInput Sheet

[fredfarmer]

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

[Richard Buttrey]

Hello F Farmer

This appears to be substantially the same as your earlier thread here
https://www.excelforum.com/excel-pro...ml#post5087049

where I think you receivef an answer to this query

We have a rule about no duplicate threads and in any case you're more likely to get an answer from those who have helped before.

Would you please continue in that thread. If you really feel this is a completely new subject the let me know and explain why. In the meantime I propose closing this thread.

Thanks for your understanding.