View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jbcsehy
 
Posts: n/a
Default how do I link data in an excel worksheet to another worksheet?

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?