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. :)
|