Report from multiple sheets
Can anyone suggest me how to retrieve data from 2 sheets into a report?
Here is the list of fields from sheet1 and sheet2
program, task name, release name, field4, field5...
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,