Hi all you excel geniuses out there! I have a table on one worksheet where each row contains data relevent to a property. I have most of this data vertically displayed and nicely formated on another worksheet so for example row 2 on worksheet one contains the data displayed in column B on the other worksheet. I would like to be able to filter worksheet one and have it so the verticle table on worksheet 2 only displays the corresponding filtered results of worksheet one.
So if i filter worksheet one and am left with rows 2, 5 and 8... i would like worksheet 2 to only display columns B, E, and H
In the sample sheet i've attached, if i filter street name in sheet 1 to "Agnes St", can i have sheet 2 auto filter to only display the columns remaining from applying this filter in sheet 1?
Thanks,
Joe
Bookmarks