View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jenn jenn is offline
external usenet poster
 
Posts: 107
Default Need to update information from one worksheet to another automatic

I have a workbook that contains 3 sheets: "Active Subcontractors", "In-Active
Subcontractors" & "Active Suncontractors-Sorted".
This workbook is just to keep up with our subcontractors information, etc.
When I update my main sheet, "Active Subcontractors", I would like for that
information to automatically update in the "Active Subcontractors-Sorted"
sheet.
I would like the easiest way to make this happen. I really do not know
anything about Macros & "linking" does not seem to be working, unless I am
doing something wrong. I am working in Excel 2000.
Thank you for any repsonses. :)