Scheduling Issue

**mokreban** · 10-23-2008, 02:55 PM

I'm attempting to retrieve information from a list of scheduling items that is not at all setup in a conventional way to make it easy for me to do what I need to do.

Basically I need to be able to search through a multi-row & multi-column array for consecutive instances of a value, each instance to return a value from a relative position in another column.

Any idea how this can be done without completely re-working the setup of this schedule? I've attached a small sample of the table I'm stuck working with.

Looking at this example; I need to be able to search the section named "ResponsibleSub", find each individual occurance of the sub abbreviation; and have a return of the relative value in the section named "ScheduleItem"

Is this even possible with the attached setup?

Thanks for your help!

-Chris

**MatrixMan** · 10-23-2008, 03:45 PM

Looking at this example; I need to be able to search the section named "ResponsibleSub", find each individual occurance of the sub abbreviation; and have a return of the relative value in the section named "ScheduleItem"

So "ResponsibleSubcontractors" is Col D; I assume ScheduleItem is Col E? So - you want to search through Col D, find "Exc." and return "F-Sch"; find "Fnd." and return "F-Sch." and so on? Where do you want it returned to / written?

**mokreban** · 10-23-2008, 06:16 PM

"ScheduleItem" is column B and "ResponsibleSub" is columns D through I.

"Fnd.", for example, is an abbreviation for our foundation subcontractor; I need to be able to find all instances of "Fnd." in columns 'D' through 'I' and have it return to me the value found in the same row of column B.

This would be easy enough if I was only trying to search for one occurance through one column; I could just do a simple vlookup. Unfortunately this is not the case.

I would like to have consecutive results returned to a section of 12 boxes in a row that would each show one of the returned values found in column 'B'.

(The intention is to build a schedule that will pull up all of the schedule items for any specific subcontractor as chosen from a drop-down list)

**MatrixMan** · 10-24-2008, 05:10 AM

Here you go ...

Please Login or Register  to view this content.

I've also attached this in your workbook. Hope that helps. MM.

**mokreban** · 10-27-2008, 05:17 PM

wow, I am simply blown away by this. I deffinately have a lot more to learn about VBA.

Thanks, this is an Issue I'd given up on when I first built the scheduling program we are using. I tend to try to make everything work using formulas; I'm going to have to study my Vis. Basic programming a bit more now that I see what it is capable of!

**mokreban** · 10-27-2008, 05:19 PM

my first lesson is going to be to study how you put all of that together!

(btw, I just read through some of the "thank you" posts and want to itterate just how grateful I am for your assistance!)