Is it possible to populate multiple column cells from selecting only one item from a drop down list, all in the same row? e.g. Column A represents codes, column B is the description and column c is a price. By only selecting a code form the drop down list in column A, how can the next two columns B&C be populated automatically?? Drop down in A1 it then needs to populate B1 to J1 etc...
I would like to utilised this function in my invoices in order to save time not having to copy and paste this information from another worksheet
I would like to utilised this function in my invoices in order to save time not having to copy and paste this information from another worksheet