Excel VBA Multiple Criteria Loop problem

[d0o0n7]

Hey Guys.. Greetings..

Hope you doing good.

I just entrap in a loop problem.

Here is the file attached with raw data dump and result desired sheets

http://www.filefactory.com/file/cbc35f7/n/Excel_Loop_problem.xls

Help requirement Details are in the sheets

I am trying this for last 1 week but

Hope will get help from this forum..


Thank you

Dev

 

[GlennUK]

I cannot use your link due to corporate security ... describe your problem and requirements.

 

[d0o0n7]

Hi Thanks for reply ..inconvenience regretted!!

I have a dataset wherein I have date ranges from 1st to 31th of month for and date instances are repeating for many employees. so here is an example
Category 1
Date EmpId Emp_Name Criteria Sub Category1 Criteria Sub Category2 Criteria Sub Category3 Criteria Sub Category4
04/01/11 000123456 Employee Temp 200 100 200 150
04/02/11 000123456 Employee Temp 150 50 100 150
04/03/11 000123456 Employee Temp 200 150 100 200
04/04/11 000123456 Employee Temp 200 150 200 200
04/05/11 000123456 Employee Temp 150 100 150 150
04/06/11 000123456 Employee Temp 200 100 50 50
04/07/11 000123456 Employee Temp 150 150 100 150
04/08/11 000123456 Employee Temp 100 150 150 150
04/09/11 000123456 Employee Temp 150 150 150 150
04/10/11 000123456 Employee Temp 150 150 150 150
04/11/11 000123456 Employee Temp 100 150 150 150
04/12/11 000123456 Employee Temp 100 150 150
04/13/11 000123456 Employee Temp 50 50 150 150



something same for other 10 employees

Now I need a loop to get the data date wise (date range say from 1st to 10th) or employee wise MTD (date range would be applicable say 1st to 10th MTD Scores for Distinct employees)..
Date Wise
Category 1
Date Empid Name Criteria Category Criteria Category1 Criteria Category2
1-Jan 000123456 Employee Temp 162.5 150 150
2-Jan 000123456 Employee Temp 112.5 100 125
3-Jan 000123456 Employee Temp 162.5 150 150
4-Jan 000123456 Employee Temp 187.5 183.3333333 200
1-Jan 000671111 Employee Temp1 And so on And so on And so on
2-Jan 000671111 Employee Temp1 And so on And so on And so on
3-Jan 000671111 Employee Temp1 And so on And so on And so on
4-Jan 000671111 Employee Temp1 And so on And so on And so on

MTD MTD Scores for ALL Employees (Date range is 1st to nth of month)

Empid Name Criteria Category1 Criteria Category2 Criteria Category3
000123456 Employee Temp MTD Average MTD Average MTD Average
000671111 Employee Temp1 MTD Average MTD Average MTD Average
000654321 Employee Temp2 MTD Average MTD Average MTD Average
000672717 Employee Temp3 MTD Average MTD Average MTD Average


Hope you get it..

Thanks Again

Dev

 

[GlennUK]

Can I ask what you are going to be doing with the date wise subset? ( i.e. why aren't you just doing an Autofilter on the required dates ... that's what you'd do if you simply wanted to view a subset )

And for MTD, have you considered simply doing a pivottable for this?

 

[d0o0n7]

Hi,

Datewise is a requirement of my Goal Sheet where I want to see data for my employees Date wise (for analysis) what they achieved in all categories.. and hmmm ... Pivot table, I could do that but I will use the information somewhere else using loop.. and I am not sure If I can pick required data from Pivot...

and this is a project where I have so many modules and using pivot in between can hamper my code speed..


Thanks

 

[d0o0n7]

I have done it!! way is altogether different from Loops.. I used ODBC Connection and ran a SQL query!! :D

Thanks for your help

Hi,

Datewise is a requirement of my Goal Sheet where I want to see data for my employees Date wise (for analysis) what they achieved in all categories.. and hmmm ... Pivot table, I could do that but I will use the information somewhere else using loop.. and I am not sure If I can pick required data from Pivot...

and this is a project where I have so many modules and using pivot in between can hamper my code speed..


Thanks