As usual I am stuck at the point where I think I can do something, I just have no idea how. And help / eg's / prods in directions appreciated.
I have a worksheet containing data for 9 divisions of my company.
The workbook, due to the sensitive nature of some of the other sheets, is in a location only I can access.
What I want to do is create 9 workbooks, each one containing only the data for that division, that will be automatically populated when updates are made to the main file.
Problem is I want these workbooks to be in a shared location and accessible by all.
First, is this possible, or will I have to move the workbook?
Second, what is the best way to go about this kind of thing?
Thanks in advance