Help! I have tried to find the answer to this posted, but I couldn't, and I would really appreceiate some help. I don't know if this is possible but here is what I am trying to do:
I want to make a phone list for our company in excel . I want one page of the workbook to be the "master", and on the other pages I can make shorter lists for each of the departments with selected numbers from the master list. Is there a way to "link" (I don't know if that is the right term) cells to the master list, so that when I have to update a number I can just do it on the master list and it will automatically update the other lists it is on?
I hope this makes sense. Thank you for your help.