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
Thanks!
You can use AutoFilter and select Chicgao in the dropdown for that column. Then copy and paste to sheet2. Only the visible cells will copy.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
sanya33, please ensure you post in relevant forum going forward - thread moved from OL forum.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Is there a way to do this without copying and pasting so that Sheet 2 would automatically generate addition info added into sheet 1?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks