ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Extract Client Refs from pivot table into another worksheet (https://www.excelbanter.com/excel-worksheet-functions/137841-extract-client-refs-pivot-table-into-another-worksheet.html)

Sarah (OGI)

Extract Client Refs from pivot table into another worksheet
 
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?


All times are GMT +1. The time now is 08:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com