RAJA MUNIDASA
New Member
my costing sheet is directly connected with the database where i have kept all the relevant prices i need. the are arranged in columns according to different specification. but some time i need to get the prices which are not stored in the same column.ex; prices of sq.box stored in a2:a30 .prices of rect. prof. in d14:d29
i pick up the item from combo box for a2:a30 which populate all sq.box items one below other.accordingly prices are inserted using index function.but some times i need the items in rect prof . also in the same combo box(when i have to use rect prof in place of sq.box. so i can pick up the relevant item and prices without recreating formulas in a different location in the costing sheet.
is it possible to insert a range in the same combo box which is not consecutive (items a2: a30 and then d14:d29 below that)?
i pick up the item from combo box for a2:a30 which populate all sq.box items one below other.accordingly prices are inserted using index function.but some times i need the items in rect prof . also in the same combo box(when i have to use rect prof in place of sq.box. so i can pick up the relevant item and prices without recreating formulas in a different location in the costing sheet.
is it possible to insert a range in the same combo box which is not consecutive (items a2: a30 and then d14:d29 below that)?
