Hi
I have a worksheet that has vlookup formulas in it. It has 2 combobox s the first combobox populates the second comboxbox. The second combobox then populates 3 cells.
Combobox Shows Category
Combobox 2 Shows Product
Cell F20 : F174 Shows Price
Cell I20 : I174 Shows Labour
My question is once the F & I cells are populated with a value I want to be able to change the value in any of these cells (Labour or Price) save those changes to the new workbook but not overwrite the original VLOOKUP formula
I hope this makes sense
Bookmarks