View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bearsfan bearsfan is offline
external usenet poster
 
Posts: 12
Default Newbie: Accessing data from one sheet and populating another

-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