Office Software Thread, Need either a formula or a code to keep a formula in a cell after it has been cleared in Technical; I have 2 cells both with comboboxes with dropdown lists.Both have vlookups & match in them.
If I select an ...
25th June 2014, 07:57 AM #1
- Rep Power
Need either a formula or a code to keep a formula in a cell after it has been cleared
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.
By DaveP in forum General Chat
Last Post: 8th January 2013, 07:15 PM
By DaveP in forum How do you do....it?
Last Post: 11th October 2011, 10:00 PM
Last Post: 24th September 2010, 09:36 PM
By sacabonos in forum Recommended Suppliers
Last Post: 9th December 2009, 12:40 PM
By SpuffMonkey in forum Scripts
Last Post: 8th November 2005, 10:31 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)