Only show data based on filtering from other sheet

[D-smoke]

Hi,
I want certain data to display based on filtering set on another sheet.

E.g.
- On sheet1 all master data is placed.
- On sheet2 the master data is copied by cell references to sheet1, so everything that is changed on sheet1 is automatically updated on sheet2.
- When filtering on sheet1, the data is not filtered on sheet2 and thereby showing all data instead of just the filtered data.

Any ideas on how to solve this?
Thanks!

[Pete_UK]

Any ideas on how to solve this?
Thanks!

Yes, but you'll need to submit a sample workbook so that I can see how your data is laid out.

Pete

[D-smoke]

Attached you have the sheet.

I want the data on sheet "Gantt Chart" to be sorted according to the filtering on the first sheet "Project Details".

Thanks a bunch!

[Pete_UK]

All columns on the main sheet have filter pull-downs. Which filters are you likely to apply to this sheet?

Pete

[D-smoke]

Well, I just want the list on the "Gantt Chart" sheet to display the same data that is displayed on the "Project Details" sheet. So, really there doesn't have to be any filters on the "Gantt Chart" tab. Perhaps just a formula that refers back to the filtered data on "Project Details" sheet?

So for example, if I filter on Project Manager on the "Project Details" (which isn't an option on the "Gantt Chart") the columns should display the same data on both sheets.

Thanks!

[Pete_UK]

I'm out at a meeting for most of today, so I'll have to leave this till tomorrow before I can look at it.

Pete