Hello, Im new to VBA and would be grateful for help from the experts in this forum.
I have created a sheet called" Consignments Sheet" that uses Vlookup Formula to search the "Data Validation" Sheet which is in the same wrorkbook for box type then retrieves the boxes dimensions from the validation sheet and puts the data into "Consignments sheet" when a box type is selected. That all works perfectly.
The Issue currently is I want to create a box type called "other" from the drop list but when the dimensions are over written by the user of "Consignment sheet" the formula will no longer exist. The only way I can think of is to write code to do a VlOOKUP for all box types and dimentions. And I don't have the knowledge to do it. Please help!
I have attached a photo below of "Consignment sheet" bear in mind there are 29 pages to the sheet where I need the VLOOKUP to work across multiple cells. I have also attached "Validation Sheet" this is where the data set is stored for box type + dimensions.
I have created a sheet called" Consignments Sheet" that uses Vlookup Formula to search the "Data Validation" Sheet which is in the same wrorkbook for box type then retrieves the boxes dimensions from the validation sheet and puts the data into "Consignments sheet" when a box type is selected. That all works perfectly.
The Issue currently is I want to create a box type called "other" from the drop list but when the dimensions are over written by the user of "Consignment sheet" the formula will no longer exist. The only way I can think of is to write code to do a VlOOKUP for all box types and dimentions. And I don't have the knowledge to do it. Please help!
I have attached a photo below of "Consignment sheet" bear in mind there are 29 pages to the sheet where I need the VLOOKUP to work across multiple cells. I have also attached "Validation Sheet" this is where the data set is stored for box type + dimensions.