Hi,

Yo may refer to question 7 on http://ashishmathur.com/knowledgebaseII.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"savbci" wrote in message
...
in Sheet 1 i have the following columns:
Date/course/Location
the table including headers is from A1:C300

In Sheet 2 I want to extract the 'Chicago' Locations and have a similar
table with only Chicago values that are in Sheet 1.

ie.
Sheet 1:
Date/Course/Location
March 1/Math/Toronto
April 15/Science/Chicago
April 20/Biology/Pittsburg
June 3/Chemistry/Chicago

Result I want to achieve in Sheet 2:
Date/Course/Location
April 15/Science/Chicago
June 3/Chemistry/Chicago

It was suggested I use auto filter and cut and paste - however I want this
sheet to be constantly updated as people add in more info on sheet 1.
thanks.