Hello --

I'm relatively new to Excel programming. Can someone here please point
me in the right direction? Here's what I need to do:

I have a 'Master Projects' worksheet, which lists all the projects
currently in our office, with notes on their various statuses and
project leaders.

I would like to create a separate worksheet for each project leader,
which will list ONLY projects that person is associated with based on
the contents of "Master Projects" (i.e., if the project name is cell
A2, this person's name would be in D2 of "Master Projects").

So, I need a Macro that scans column D of "Master Projects" and when it
finds a certain text string (the name) in row X, returns the value of
cell AX, and then continues onward to the end of the range specified.

My first question is, can this be done with Macros? If so, can anyone
offer me a tip on where to start? All the resources I am now finding
deal with recording Macros... which isn't exactly what I need right
now. Thanks so much!

Regards,
Mike


--
graphicGuy
------------------------------------------------------------------------
graphicGuy's Profile: http://www.excelforum.com/member.php...o&userid=33603
View this thread: http://www.excelforum.com/showthread...hreadid=533806

Hi Mike:

Consider using Autofilter rather than a macro. By filtering on person's name,
you generate separate tables for copy/paste

For a macro version of the same thing, use the macro recorder to get the
basics and enclose it in a loop.
--
Gary''s Student


"graphicGuy" wrote:


Hello --

I'm relatively new to Excel programming. Can someone here please point
me in the right direction? Here's what I need to do:

I have a 'Master Projects' worksheet, which lists all the projects
currently in our office, with notes on their various statuses and
project leaders.

I would like to create a separate worksheet for each project leader,
which will list ONLY projects that person is associated with based on
the contents of "Master Projects" (i.e., if the project name is cell
A2, this person's name would be in D2 of "Master Projects").

So, I need a Macro that scans column D of "Master Projects" and when it
finds a certain text string (the name) in row X, returns the value of
cell AX, and then continues onward to the end of the range specified.

My first question is, can this be done with Macros? If so, can anyone
offer me a tip on where to start? All the resources I am now finding
deal with recording Macros... which isn't exactly what I need right
now. Thanks so much!

Regards,
Mike


--
graphicGuy
------------------------------------------------------------------------
graphicGuy's Profile: http://www.excelforum.com/member.php...o&userid=33603
View this thread: http://www.excelforum.com/showthread...hreadid=533806