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 ...