J
Jim
Hello,
I have a spreadsheet set up to track daily sales, quotas, etc with a
seperate sheet in the workbook for each month of the year. There is one for
each salesman (currently 12) in this region, that I need to link to a
regional workbook for a pivot chart. The problem is that I need to
distribute the same sales spreadsheets and regional workbook to other
regional managers (exact # not known at this time) so they can track the
sales in their territory without knowing the names of the other salesmen. Is
there a way to dynamically link a workbook or spreadsheet to multiple
others, by having the user (regional manager) fill in the file names of the
spreadsheets he wants to link to without knowing the names in advance? The
end result being that the individual managers pivot chart will work, as well
as one at the home office that links to all the regional managers?
Thanks
Jim
I have a spreadsheet set up to track daily sales, quotas, etc with a
seperate sheet in the workbook for each month of the year. There is one for
each salesman (currently 12) in this region, that I need to link to a
regional workbook for a pivot chart. The problem is that I need to
distribute the same sales spreadsheets and regional workbook to other
regional managers (exact # not known at this time) so they can track the
sales in their territory without knowing the names of the other salesmen. Is
there a way to dynamically link a workbook or spreadsheet to multiple
others, by having the user (regional manager) fill in the file names of the
spreadsheets he wants to link to without knowing the names in advance? The
end result being that the individual managers pivot chart will work, as well
as one at the home office that links to all the regional managers?
Thanks
Jim