lookup
 

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.

lookup
 

I've just responded to this at your other thread - please don't multi-
post.

Pete

On Sep 18, 8:01*pm, savbci wrote:
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.