Skip to Content
0
Former Member
Nov 20, 2009 at 12:29 PM

Hiding Rows with data in a workbook, Only display Results

38 Views

Good day

Please assist.

Firstly - I am supressing 'repeated key values' in a workbook and secondly displaying the 'results' for a certain characteristic on the 'top right'. The following is the result:

Cal. year / month 2009/10

Customer Suffix Preferred Stocking P Wip Number Number of WIP lines Lines filled (P)

30 LTS Result 36 32

10673 5 5

63573 8 8

64368 23 19

63 LTS Result 2 2

10376 1 1

64822 1 1

The user only want to see the Results for each customer suffix and preferred stocking point...as follows:

30 LTS Result 36 32

63 LTS Result 2 2

This is the only way I could structure the query to get to the required results

Seems as if the only way to hide the rows beneath the results if with VB code. Can someone assist me with that please?

thanks

Cj