Hi Bruce,Thank you for responding.  I do not know how to attach the form to show you. (is this possible?)I tried your script above but nothing happened.I gave an example in my initial question above however the real table numbers are below.When filling out Table5, it copies the data to Table21.When ...

Please help! Due date today!Table 1 has add Row button which adds a new row to Table 1 and Table 2.  When Table 1 is filled out, it copies all data to Table 2.When the new row in Table 1 is filled out, I cannot get the data to copy to the new row in Table2.Any assistance would be most appreciated.