link tables

Hi
Whilst you have added a copy of your spreadsheet you have not shown us what you currently have and what the end product is that you need. Without that it is difficult to help you. Post a sample of what you have and then a copy of what you want to achieve. This will help us understand what you need and be able to help you better.
Tony

In the spread sheet, I need for the data entered in each row on sheet AMTS1 to populate the corresponding rows columns on sheet ATS 1. If something is removed from AMTS1 then it needs to reflect on ATS 1. Both need to auto add lines as well. I have put a button to delete rows but if it can delete them if something is removed from AMTS 1. Hope this explains what I need.