Hi guys,
I am quite confident in Excel but rarely used VBA.
I need to set up a sales database which is used on sharepoint by several sales persons.
The excel consists of 3 sheets: One with the data base and the relevant information, one with a legend for the dropdown list and one for pivoting.
In the data base tab there is one column called "KAM" with all the sales represantives and in the following columns the project informations.
Now what I would like to do ist that the sales guy using the excel can see only his projects, while the others are hided and, in best case, cant be edited.
I dont know if therfore a login macro is needed and in next step how this can be linked to the main sheet to autofilter the list.
Hope somebody can held me.
Thanks in advance,
Alex
I am quite confident in Excel but rarely used VBA.
I need to set up a sales database which is used on sharepoint by several sales persons.
The excel consists of 3 sheets: One with the data base and the relevant information, one with a legend for the dropdown list and one for pivoting.
In the data base tab there is one column called "KAM" with all the sales represantives and in the following columns the project informations.
Now what I would like to do ist that the sales guy using the excel can see only his projects, while the others are hided and, in best case, cant be edited.
I dont know if therfore a login macro is needed and in next step how this can be linked to the main sheet to autofilter the list.
Hope somebody can held me.
Thanks in advance,
Alex