Restricting Data access on basis region

VENKYS

Board Regular
Joined
May 19, 2009
Messages
101
Dear All.. Good Morning..
Need a help / guidance as am struck with a peculiar problem
I have a huge data on profitability banding which is pertain to almost 45 teams... as of now i am sending split files to each of these teams. It becomes a tedious task as i have to include summary, then detail extract, not to mention graphical display. These contain profitability banding too so I cannot share a common file..
Is there a way out to send a common file..But display only records pertaining to mentioned user group..
I plan to fix a key word to each group and sent it to them.. based on their input on main page (form).. related details should be displayed to them in another sheet which they could use upon.
Or is there a better option
Any guidance..Thanks in advance
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
you can play with Power Query and Protect Structure
or
Review -> Allow Users to Edit Ranges

however, protection in Excel is illusory
 
Upvote 0

Forum statistics

Threads
1,215,530
Messages
6,125,353
Members
449,220
Latest member
Edwin_SVRZ

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top