dasarihp_newid
Registered Users (C)
Hi friends,
I wanted to give you a tip on how to scan the excel for the full month in one shot, once you get the cases for almost each day. Since now almost all the members here already have scan results for their dates, it will be easy..
Like, suppose A scans 1 sept, B scan 3 sept, C scan 8 th sept and so on... you will all need to put all the different date's cases into one date, say into 1 sept cases(one under another).. so you will now have all the 140's of different dates in 1st sept excel sheet.. Then when you press Alt-F8 select the 1st sept case number and run.. This will run all the cases in that sheet which includes the dates of all of sept.. and you can then filter which are approved, which are RFE's easily with one run..
I am attaching my August Excel here as an example.. I removed lots of approved/completed cases from the excel.
You guys can have your own monthly excel file..
I wanted to give you a tip on how to scan the excel for the full month in one shot, once you get the cases for almost each day. Since now almost all the members here already have scan results for their dates, it will be easy..
Like, suppose A scans 1 sept, B scan 3 sept, C scan 8 th sept and so on... you will all need to put all the different date's cases into one date, say into 1 sept cases(one under another).. so you will now have all the 140's of different dates in 1st sept excel sheet.. Then when you press Alt-F8 select the 1st sept case number and run.. This will run all the cases in that sheet which includes the dates of all of sept.. and you can then filter which are approved, which are RFE's easily with one run..
I am attaching my August Excel here as an example.. I removed lots of approved/completed cases from the excel.
You guys can have your own monthly excel file..