ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Update individual worksheets from Master Worksheet (https://www.excelbanter.com/excel-programming/440151-update-individual-worksheets-master-worksheet.html)

Robin Ryan

Update individual worksheets from Master Worksheet
 
Each month I open and update about 40 commission worksheets with data from my
master workbook, and then email each statement. Very time consuming. Is
there a way that I can send the users their own (confidential) worksheet and
have that automatically update via some web service? The master workbook is
very large and contains confidential info.


JLGWhiz[_2_]

Update individual worksheets from Master Worksheet
 
Have you looked into getting you own LAN? Basically, you set up your own
server(s) and put up a firewall to prevent (in reality, minimize) outside
access to your internal communications. You would still be able to access
the I-net through your domain interface.


"Robin Ryan" <Robin wrote in message
...
Each month I open and update about 40 commission worksheets with data from
my
master workbook, and then email each statement. Very time consuming. Is
there a way that I can send the users their own (confidential) worksheet
and
have that automatically update via some web service? The master workbook
is
very large and contains confidential info.





All times are GMT +1. The time now is 05:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com