Linking columns in excel 2000

[jbs1946]

would like to create a 2nd sheet which has selected colums in first sheet so that second sheet will be updated when first sheet is changed or records are  added. How would i go about this?i have 900 entries in first sheet

[Sidewinder]

Check out this site for a nifty little function that should make your life easier:

http://www.j-walk.com/ss/excel/tips/tip63.htm

Hope this helps.