Hi,
Using Excel I'm building a simple spreadsheet database of all football
results in a league each season, with a master 'Results' worksheet containing
the following columns: -

Master 'Results' worksheet

A B C D E F G
Date Home team Away team H/T score F/T score


I'm then creating a separate worksheet for each team within the league to
record (amongst other things) just that team's results.

Using the master 'Results' worksheet above, I want Excel to automatically
copy across into each individual team's worksheet the data above but showing
only the rows containing that individual team's name, i.e. the relevant team
is listed either in Column B (Home team) or Column C (Away team).

Using answers to previous questions in the Forum I've managed to build an
expression that will do this - but only for one column (B only or C only - so
I get a listing of either 'Home' games or 'Away' games - but not both
together in date order), and I'm struggling to find an expression that will
automatically copy the relevant rows over where the team is found in EITHER
column B or C.

I don't know anything about Macros so if anyone can help with an either/or
expression that would work, to produce a gap free list in each individual
team's worksheet, I'd be very happy to stop banging my head against hard
surfaces.

Many thanks.

--
Steve Sharpe