Display Projects from a list using a Macro.

**Irish RayRay** · 05-03-2012, 08:40 AM

Hi all,

I have have been trying this for awhile now with no look.

I am trying to do something similar to SUMIFS but with say project names.

so say i have something like

| | A | B | C | D | E |
|1|Name|Number|Project| Joe | Joe |
|2| Joe | 1 | aaa | 5 | aaa, ccc|
|3| Jack | 2 | bbb | | |
|4| Mike | 3 | ccc | | |
|5| Joe | 4 | ccc | | |
|6| Mike | 5 | bbb | | |

theres an example also included as attachment

So what i want is like SUMIFS as when Joe is Wrote in D1 then in D2 it sums all the number to do with him and then what i cant do is if you type say Joe into E1 in E2 it adds all the projects joe is working on.
So if i decided to put in mike then it would display all the projects mike worked on.

Trying to do this using a macro just no luck so far.

So i need the macro to run along Column A say and if it finds the Name Joe then take Related data.

All comments will be appreciated.
Thank You

**WHER** · 05-03-2012, 09:42 AM

Maybe like this:

**Irish RayRay** · 05-03-2012, 09:48 AM

Thank you thats perfect

**Irish RayRay** · 05-04-2012, 05:59 AM

Ok im re-opening this because as the code does what i want and have modified the code ever so slightly to work with the project im using it on.

Im trying to see if its possible to do it exactly like the sumIfs so that there can be range 1 criteria1,............,range 14 criteria 14 so that it is limitless pretty much.
I am working on it at the moment but was looking for any hints or tips on how to do this.

thank you

**WHER** · 05-04-2012, 07:39 AM

Maybe you can replace the attachment in post 1 with a new one, to help visualise what you're asking.

**Irish RayRay** · 05-14-2012, 09:44 AM

Sorry about taking so long to Reply for some reason didn't get an email.

Ok so I have updated the Attachment and as you can see i have slightly modified your code but that is just to allow you to select the cells you want instead of it always being column 3 i started working on if you put in a date it will find the names this works so far using the code you gave me but i am going to try and modify it so that if you type in like < 12/12/2010 it will show all projects related.
I haven't done much on this as i'm creating something similar to the List thing but splitting in stead which prompts the user to choose how they wish to split but any help with the first thing will be appreciated.
Thank You