Show schedule differently on multiple sheets?

[KGC]

Is it possible to show a single schedule with different results/data on different sheets.

For instance. I have a schedule with information pertaining to Path o Travel distances for both the first and second floor. I want only the first floor data to show on sheet one and then only second floor data to show on sheet two.

All i can think of at the moment is to use grouping and header to separate the information by floor, but it's still the same schedule on both sheets.

[Simon.Whitbread]

You are right, it displays the same on all sheets.

The way around this is once you have the schedule looking the way you want, duplicate it, and then apply a filter to both, one to display first floor data, the other, second floor... And so on.

It doesn't matter that you have multiple schedules, what is important is getting the initial one set up correctly in the first place