I have a pivot table that lists information by client ref, showing the value
of business done by each client, split by the company with whom the business
is placed, then by the class of the product, then by the product line.
I need to pull out each of the client refs shown on the pivot table (from
column A) and put them into another worksheet in the same workbook, as a list
of clients that have placed business during that period. However, there may
be a different number of clients listed each time, with each client ref shows
varying rows of information, i.e. there is not a set number of rows between
each client.
What formula can I enter on my other worksheet so that I can pull out the
references as a list?