Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie: Accessing data from one sheet and populating another
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie: Accessing data from one sheet and populating another
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data sheet populating into multiple sheets | New Users to Excel | |||
Populating one sheet with data from other sheets | Excel Programming | |||
populating sheet with data from other sheets | New Users to Excel | |||
Newbie question about accessing Excel sheet from the web | Excel Programming | |||
Newbie question on accessing data in xls | Excel Programming |