Creating a link for particular information

S

suek

Hello!

I am recording work done by companies in different documents based on the
site of the job. So all the work done at location A is in one document,
location B on another document etc. The project managers access just the
locations they are working on.

I have been asked to monitor the work of one company across all sites, so am
trying to create a link whereby whenever I enter the Company name
theinformation in that row will automatically write to another document. Can
this be done?
 
S

suek

Thanks for the links.

I have straight links and have no problems there, but I am just trying to
write a formula in the destination workbook such as:
=(document name) (spreadsheet name) A1:G300 where A = (company name)
and then get a list of all the jobs they have charged us for on all the
projects upon which they work.
 
Top