Autofill one column from another

[feinj]

Hi everyone,

I have a situation where, in a query, I need to autofill the column called "Xferd Vendor No" from the column called "Vendor No", where if the data in the Vendor No column changes, then the autofill changes to match.

Please see the two attached files. The one called Autofill Raw Data.xlsx shows the expected query results. The one called autofill Final Output.xlsx shows the final results I need when the task is completed.

 

[pr2-eugin]

Would Autofill or Cascading ComboBox option work for you?

 

[feinj]

HI pr2-eugin,

No this will not work for me since neither of these deal with this specific situation.

Thanks,