Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GROUPWORK IN EXCEL
picture 10 hotels with identical pages for budget/actual line items (maybe
even a 12-month spread to a 13th total column. anyhow, corporate has a 'master' spreadsheet with individual pages for each of the 10 hotels, and a summary for the corp on page 11. need to have someway for each specific hotel put their current actual info in for sales, expenses, etc. and the 'link' back to the corporate master. ideally going via the internet to a specific url from the specific hotel to the ID of the corporate sheet. something like this possible? or other alternatives for groupwork in excel so that individuals can affect their area but it will update to some foreign overview of all. thanks. jim |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GROUPWORK IN EXCEL
fyi
this worked fine. a corporate sheet at 1 location can refer to a 'hotel' sheet on another machine at another location. ='\\192.168.1.10\vol3\[test1.xls]tampa downtown'!$D$2 thanks. jim "jim sturtz" wrote in message ... picture 10 hotels with identical pages for budget/actual line items (maybe even a 12-month spread to a 13th total column. anyhow, corporate has a 'master' spreadsheet with individual pages for each of the 10 hotels, and a summary for the corp on page 11. need to have someway for each specific hotel put their current actual info in for sales, expenses, etc. and the 'link' back to the corporate master. ideally going via the internet to a specific url from the specific hotel to the ID of the corporate sheet. something like this possible? or other alternatives for groupwork in excel so that individuals can affect their area but it will update to some foreign overview of all. thanks. jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |