Hello,
I have a table with lots of work orders for my office and I'm trying to separate them out by floors. The output from our work order application reads like this:
A B C D E 1 2 3 4 5 6 # Floor Work Location ID Task Name 7 01 \Locations\DCCII\9th Floor\N9-01J 111,111 Cold Call 8 02 \Locations\DCCI\9th Floor\W9-05L 111,112 Light Out 9 03 \Locations\DCCIII\5th Floor\E5-01A 111,113 New Chair
I've added the column B myself, and I'm trying to have two things happen:
1st, I want to perform a search on Column C and pull out the floor information for Column B. For the cells in my example, if would pull out N9, W9 and E5. However, there are 15 floors at my office, E4, E5, N1 - N11, W8 and W9. I tried to have this searched with a ISNUMBER, but it got goofy with so many choices. The reason I can't just have it say floor is because we have multiple buildings, so there are, for instance, two 9th floors (one called W9 and another called N9).
2nd, I'd like to perform a search on Column B and then input the entire line onto another worksheet. That way, I could have a separate worksheet for each floor in my office. I have no idea how to go about this one.
Any help would be appreciated, and if I'm missing something or if I need to provide more information, let me know. Thanks!
Bookmarks