Hi Again,
I have been trying to create a monthly report based on data that I have in another worksheet(same workbook).
And, this is what I'm trying to do on the monthly Report sheet
System Impacted Date Reported(Col E)
GCMS 22jul06
Trackwise 20Aug06
IsoTrain 25Aug06
I want to only report incidents/systems occured in a certain calender month. I'm using advanced filters and a criteria like $E10=>'Report Parameters'!$E$4 and $E10<='Report Parameters'!$F$4.
Note: Report Parameters is another sheet where I have user enter start date manually entered in E4 and End date entered in cell F4.
Any suggestions or other approaches is appreciated.
[/list]
I have been trying to create a monthly report based on data that I have in another worksheet(same workbook).
And, this is what I'm trying to do on the monthly Report sheet
System Impacted Date Reported(Col E)
GCMS 22jul06
Trackwise 20Aug06
IsoTrain 25Aug06
I want to only report incidents/systems occured in a certain calender month. I'm using advanced filters and a criteria like $E10=>'Report Parameters'!$E$4 and $E10<='Report Parameters'!$F$4.
Note: Report Parameters is another sheet where I have user enter start date manually entered in E4 and End date entered in cell F4.
Any suggestions or other approaches is appreciated.
[/list]