andyhcc
11-13-2008, 11:39 AM
Hi everyone ..I am new here...
I have some date in Excel sheet. See the attachment
-------------------------------------------
How can I use VBA make those date become the table in a userform (better) or in a sheet?
1. NO. - Every NO. that exits in the Data
2. Count - Count of each NO.
3. Failed _ Count of each NO. that is "Failed"
4. Failed Rate - (Failed / Count) %
5. Sort by "Failed Rate" Descending
6. The data in the table will change once the data is changed
Thanks for help
Andy
------------------
It's a little bit like the the Pivot Tables but the format is not what I want.
See the new attachment at #4
I have some date in Excel sheet. See the attachment
-------------------------------------------
How can I use VBA make those date become the table in a userform (better) or in a sheet?
1. NO. - Every NO. that exits in the Data
2. Count - Count of each NO.
3. Failed _ Count of each NO. that is "Failed"
4. Failed Rate - (Failed / Count) %
5. Sort by "Failed Rate" Descending
6. The data in the table will change once the data is changed
Thanks for help
Andy
------------------
It's a little bit like the the Pivot Tables but the format is not what I want.
See the new attachment at #4