I have 2 cells both with comboboxes with dropdown lists.Both have vlookups & match in them.
If I select an item from the dropdown box in one the other is automatically filled in with the corresponding data.
The problem is once I have selected something in one it removes the formula from the cell behind it.
So when I need to make a change but have to use the other combobox it doesn't bring across the data automatically anymore.
Please help.