praktikant
New Member
- Joined
- Dec 9, 2014
- Messages
- 9
Hi everyone,
I've been working on a "Customer-workbook" for myself and another for a distribution company - "Distribution-workbook" . So 2 excel workbooks.
We are using sharepoint, so the excel files will be places in two different workspaces.
What I'm looking for is that the "Distribution-workbook" only show the "type 1" customers and pull the data from the customer-sheet
I've tried to make a copy with the requirements in a second worksheet in the "Customer-workbook" and then have the "Distribution-workbook" automatically importing from the specific worksheet that only have the "type 1" customers.
I cant use filters, because the distribution company aren't allowed by law to see the type 2 customers.
1: this is the main source - the Customer Sheet
2: the Distribution sheet
I've been working on a "Customer-workbook" for myself and another for a distribution company - "Distribution-workbook" . So 2 excel workbooks.
We are using sharepoint, so the excel files will be places in two different workspaces.
What I'm looking for is that the "Distribution-workbook" only show the "type 1" customers and pull the data from the customer-sheet
I've tried to make a copy with the requirements in a second worksheet in the "Customer-workbook" and then have the "Distribution-workbook" automatically importing from the specific worksheet that only have the "type 1" customers.
I cant use filters, because the distribution company aren't allowed by law to see the type 2 customers.
1: this is the main source - the Customer Sheet
2: the Distribution sheet
