i know i am asking a dumbkid question, but is there a way to code this to a button? the reason for this is because in order for the data to transfer the F4 with the "y" has to be the last field input in order to export the data. Retraining an old habit out of someone is combersome, because the person filing the sheet out knows ahead of time on wether the "y" or "n" goes in place and is attempting to input that field before the rest of the data. therefore it is not transfering all the data, just the data prior to the "y". With a button or or if you have a better solition all the data on the row will be transfered based on the "y" reguardless of the order the data is input....