In one worksheet, I have a pivot table showing client ref in column A - the
refs being shown at varying intervals.
In another worksheet, I need a list in column A to show each of the client
refs from the pivot table.
How can I do this? I thought it might be a Count function but not sure how
you then show the results as a list?
Any ideas?