Cell Link for combo box in Excel : Relative or absolute?
Well, using only 1 combo box is fine without caring about cell link's being relative or absolute. But when I copy the cell containing the combo box, I need the cell link to be relative.
Here's something to visualize the problem:
Think of an order form. I got 100 orders in the list. And I got a column which I want to put a combo box with selections "paid" or "not paid" . Well, I put my first combo box in my first order. But when I copy that cell down for the remaining 99 orders, all the combo boxes that I created (for the other 99 orders) all are linked to the FIRST order's combo box's cell reference. However I want that cell's reference to be relative so that when I copy the cell(and the combo box as well, as that cell contains containing the combo box) their cell link is changed. I need this cos I may have 10000 orders for example and modifying all the cell refeences of all those orders's combo boxes may be annoying.
Any help is welcomed. Thanks in advance.