hi i am creating a consolidated file but i am unable to attach the excel file.please go through the link http://www.ozgrid.com/forum/showthread.php?t=194942
1st the sheet i asked the same question at orzid please find the post accuracy in vba but date wise..
now what i want in the sheet ,the refresh button in the sheet 1 which is database sheet and in pivot sheet i want when i press the refresh button i will get automatically in sheet 2 that (transaction date and row label date) which is QC date comes up automatically when i press the refresh button and everything like count of Xid ,pass,fail,average QC score and accuracy score ,weekly trend whenever i press that refresh button and
what i noticed that accuracy score is not changing ..it is coming same..it is showing 91.14% only..every time i refresh..please look into that even in the Weekly trend it is showing 91.14
i am unable to attach the excel file ,but i have given the link please go through it it has the excel file
..i know it seems impossible you are the hope sir,,please help me