Hey guys, searched around a bit and still can't find a solution to my current frustration, help would be much appreciated.
What I have is a long list of cost codes, that are to be user defined, that I upload into our construction accounting software. To track productivity each cost code must correspond to a specific installation type and location (ex. 2" Copper pipe, Overhead). Each job can have hundreds of codes. For each cost code and row, the current solution is to select the defining parameters from a drop down list. With 15 zones and 99 installation types this is very time consuming. There are also pre-defined codes for each job, but those don't need changing. We put an "x" by each pre-defined code and each user defined code that we want to use and filter the column so the sheet only displays the needed codes.
What I'm trying to do is streamline the process with an array. I have Installation type listed by row with the 15 locations in columns. An 'x' in the corresponding square should then put that data with a corresponding code on another sheet.
Here's an simplified view of the RESULT I want:
My problem is in displaying the selected values in a column without lines upon lines of blank space. I need each value on the next row to be able to populate the list of codes in ascending order. I've tried nesting IF statements (if this cell = x, that cell = corresponding installation type and location, if not this cell = next cell) but i can only next 64 and that formula is HUGE (and not working anyway..)
Any help would be great!