how do I link data in an excel worksheet to another worksheet?

[Guest]

I have created a workbook for office inventory. I would like to have a
master sheet with all info and other worksheets where the information is
broken down into categories from the master. For example - I have computers
that students, researchers and my remote office use. I would like to
transfer the information from the master to the subsequent worksheets
(Student Computers, Researchers, Remote Office, etc.) and be able to edit on
the master and have all information on the worksheets automatically update.
Is this possible?

 

[Guest]

Yes it is possible but you are virtually asking for a program type utility.
you should consider "Hiring" someone for this task. This help site is for
basic yes/ no questions and fully functional utilities are not free.

See my site
http://au.geocities.com/excelmarksway

For a "utility" for the deed will cost you between $800 and $1500, and may
take up to six weeks to complete, depending on how much information is
forthcoming.