Hi all,

There are 3 sheets in a single xl file:

Sheet 1: It contains the template to be populated with the information
from the other sheets
It contains only selected columns from sheet 2 and sheet
3 whose values need to be populated in sheet 1.

PART 1: Sheet 3: contains 3rd column as "subproject id":
and has different columns containing the
subproject details
Aim of code:
1. extract all the subproject ids into sheet1:from sheet
3 in the defined range of cells in sheet1 under the
same column heading "subproject id"
2. And then pull the information for all those subproject
ids (the information requires to be pulled only
from the selected columns in sheet 3 which are given
the "same column name" in sheet 1)

PART 2: Sheet 2 contains the "Project id" column name and several
other columns containg information of the
project pertaining to that project id.
Aim of the code: User enters the project id in template 1
and the POPULATE button should
populate the information in various cells
(In sheet 1:like cell A3:
contains name "Project Status"
cell A4: should
extract the value of the Project status from sheet 2 under the
column name
"Project status".
And similarly this repeats for a
couple of fileds)

Any help would be appreciated.

Thanks