Hello all,
First post here. I'm trying to find a way to make my spreadsheet autopopulate one of 2 columns based on which one the user enters data into. Basically my workbook contains one table which holds product numbers and product names. Another table is used to create new orders. I'd like my users to be able to select either the name or the number, and have whichever one they don't select autopopulate. Make sense?
Thanks guys.
Keith
First post here. I'm trying to find a way to make my spreadsheet autopopulate one of 2 columns based on which one the user enters data into. Basically my workbook contains one table which holds product numbers and product names. Another table is used to create new orders. I'd like my users to be able to select either the name or the number, and have whichever one they don't select autopopulate. Make sense?
Thanks guys.
Keith