I have an excel table with sales data for many presellers. I have to make and updating table for each of presellers. I want to make one file with data for all presellers and to create a shortcuts to preseller folders and when some preseller opens file from his location I want excel to aply filter, filtering only his data (filter would be ID_preseller). Folder name is filter value.
If this is not posible, I want to create a dialog box wich would be promting for ID_preseller on opening excel file, and aplying a filter wich would showing only his data. Presseler would type his ID.
It would be great If someone could help me with this becouse I would not have to update more than 50 files but only 1.
PS: Every preseller have to open the file from his folder and have to see only his data.
If this is not posible, I want to create a dialog box wich would be promting for ID_preseller on opening excel file, and aplying a filter wich would showing only his data. Presseler would type his ID.
It would be great If someone could help me with this becouse I would not have to update more than 50 files but only 1.
PS: Every preseller have to open the file from his folder and have to see only his data.
