Hi Chandoo,
I'm trying to develop a project status report.We have different projects (machine manufacturing)Each project(machine)has many components which are to be manufactured by different operations like machining,fabrication etc.,The link will clearly explain u the linkages between the sheets. I'm looking to link the sheets 1,2,3,4,5 to the 'status'sheet where each row in the sheets 1,2,3,4,5 with the finish date beyond today should appear in the 'status' sheet.(i.e unfinished operations should appear in the 'status' sheet). please help.
http://rapidshare.com/files/437243251/trial1.xls
I'm trying to develop a project status report.We have different projects (machine manufacturing)Each project(machine)has many components which are to be manufactured by different operations like machining,fabrication etc.,The link will clearly explain u the linkages between the sheets. I'm looking to link the sheets 1,2,3,4,5 to the 'status'sheet where each row in the sheets 1,2,3,4,5 with the finish date beyond today should appear in the 'status' sheet.(i.e unfinished operations should appear in the 'status' sheet). please help.
http://rapidshare.com/files/437243251/trial1.xls