-Hello,

I am trying to map projects using an excel macro button. User would input
project information into one sheet i.e. project start date, testing duration
and go live date and then macro would input the new project name and find the
corresponding date on the other sheet and factor in the weeks of testing
duration and map the project accordingly. Here's a crude model:


10/4/ 10/11 10/18
Project Name1 testing testing release
Project Name2 testing release

You can use the worksheet_change event to have a macro react to entries on
your input sheet.

http://www.cpeason.com/excel/events.htm

has an overview of events.

--
Regards,
Tom Ogilvy



"bearsfan" wrote:

-Hello,

I am trying to map projects using an excel macro button. User would input
project information into one sheet i.e. project start date, testing duration
and go live date and then macro would input the new project name and find the
corresponding date on the other sheet and factor in the weeks of testing
duration and map the project accordingly. Here's a crude model:


10/4/ 10/11 10/18
Project Name1 testing testing release
Project Name2 testing release

Thanks for the help Tom!

"Tom Ogilvy" wrote:

You can use the worksheet_change event to have a macro react to entries on
your input sheet.

http://www.cpeason.com/excel/events.htm

has an overview of events.

--
Regards,
Tom Ogilvy



"bearsfan" wrote:

-Hello,

I am trying to map projects using an excel macro button. User would input
project information into one sheet i.e. project start date, testing duration
and go live date and then macro would input the new project name and find the
corresponding date on the other sheet and factor in the weeks of testing
duration and map the project accordingly. Here's a crude model:


10/4/ 10/11 10/18
Project Name1 testing testing release
Project Name2 testing release