Report from multiple sheets

Hi,

Can anyone suggest me how to retrieve data from 2 sheets into a report?

Here is the list of fields from sheet1 and sheet2

Sheet1:

program, task name, release name, field4, field5...

Sheet2:

program, release name, field3, field4,field5....

Program and release name is the common from both the sheets. Sheet1 has main and subtask and I would like to have this in the report connecting to Sheet2 with other fields.

Thanks in advance,

Chitta

Best Answer

Answers