View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jenna Jenna is offline
external usenet poster
 
Posts: 20
Default Linking multiple worksheets to one summary sheet

I am creating a Lead Tracking workbook for the agents that work in my real
estate office. There are 5 worksheets for 5 different types of customers
that we work with in our office. I would like to create a 6th sheet in the
workbook which has all of the contacts on one sheet and would update
automatically. There would be name and numbers. I know about Access,
however, that is far too advanced for my agents to use. HELP!!!!