Devam Ediyor

479216 Excel Filter Sub Routine

I am looking to use the results of an autofilter on one worksheet to filter other worksheets.

For example say I have this on Worksheet 1

Name Hometown Favorite Sport

Joe City1 Gymnastics

Bob City2 Bodybuilding

Tim City1 Gymnastics

Ryan City1 Football

Kim City3 Softball

Bryan City2 Hunting

Matt City4 Basketball

Tony City4 Racecars

This on worksheet2

Name Favorite Vacation Spot

Joe Hawaii

Bob Alaska

Tim Vegas

Ryan Florida

Kim California

Bryan Indiana

Matt Indiana

Tony North Carolina

Tony California

And I apply a filter on "Hometown" in worksheet1 I only want the "Names" displayed in the results of the filter to appear on the other sheets.

So if I put a filter on "Hometown" of "City4" in sheet1 on sheet2 I only want to see the rows with "Matt" and "Tony" as the name.

The "Name" is the key linking the sheets together. a particular name may appear twice in sheet 2.

Beceriler: Her şey Kabul, Excel

Daha fazlasını görün: tony, ryan , north carolina, Hawaii, filter, bodybuilding, alaska, excel sheet linking, linking excel, football results, excel rows, vacation excel, excel sheet vacation, worksheet excel, tony kim, sport results, filter excel, excel filter, routine, excel sub, excel worksheets, filter results, rows excel, football excel, football results excel

İşveren Hakkında:
( 23 değerlendirme ) Blacklick, United States

Proje NO: #2225126

Seçilen:

rfreelancer2008

Anything to do with Excel. Escrow requested please.

1 gün içinde 10$ USD
(94 Değerlendirme)
5.6