View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NickySams NickySams is offline
external usenet poster
 
Posts: 4
Default Combine multiple sheets (categories) into one master sheet

I have several sheets in my workbook that have solutions to common problems
we encounter here in the office. What I want is to have the separate
categories as sheets, which I currently do, and one that has all of the
categories together on one sheet, which I also have. My problem is that if I
change one of the solutions either on the master list or in the category, it
doesn't update in the other location. How would I make this possible? I
apologize if the question is confusing. Heh.