Minimum Value in a Grouping of rows

[canada]

Hi,

I have a grouping and subgrouping of rows in my worksheet and I want to use the minimum value from each group and subgroup and use those values in a report on a separate worksheet using vba. Here's the situation

Emp List (Column)__________________________ Salary
- Workers
__+ Foremen
__- Juniors
____John__________________________________2000
____Max___________________________________1800
____Sandra_________________________________1925
- Management
__+ Seniors
__+ Middle

Lets say Max has the lowest salary among all the workers then I want the report to look like this

Emp Group__________ Emp____________________ Min Salary
Workers____________ Max____________________ 1800

Can I do this using vba without multiple loops at all the group levels? Any help will be most appreciated. Thanks a lot!

 

[guerillaunit]

Hi,
Can you upload your workbook onto a file sharing site and post the link?

 

[canada]

I am new to this - can you please suggest a suitable and safe site...Many Thanks!

 

[canada]

After some looking around, I was able to post the sample sheet on the Google Docs. Since the data is confidential and also huge, I have only posted a sample here. Here's the link

https://docs.google.com/open?id=0B6ynjVio6tkGeHBEN0JZMXpKc2M

Any help will be most appreciated...Thanks a ton!

 

[canada]

Folks - I have been at my wits' end here - any help will be most appreciated - Thanks a ton!

 

[guerillaunit]

Can you upload an Excel version of the file? I am guessing that your workbook has several Excel groupings which the document images you put on Google don't reflect

 

[canada]

The excel version has been uploaded at Google Docs...Thanks!

https://docs.google.com/open?id=0B6y...HBEN0JZMXpKc2M

 

[canada]

You can download the file from the link as an excel sheet and you will be able to view all the groupings...thanks.