In a\league schedule i have 18 different weeks of fixtures, is it possible to
select a weeks fixtures on a diiferent sheet by using week numbers, e.g if i
put week1 in a cell the fixtures for that week will be displayed
--
thanks

First, have a look in help index for weeknum

--
Don Guillett
SalesAid Software

"Mike" wrote in message
...
In a\league schedule i have 18 different weeks of fixtures, is it possible
to
select a weeks fixtures on a diiferent sheet by using week numbers, e.g if
i
put week1 in a cell the fixtures for that week will be displayed
--
thanks

I just need to select some data on one sheet and transfer it to another by
using a number relative to our league weeks.
--
thanks


"Don Guillett" wrote:

First, have a look in help index for weeknum

--
Don Guillett
SalesAid Software

"Mike" wrote in message
...
In a\league schedule i have 18 different weeks of fixtures, is it possible
to
select a weeks fixtures on a diiferent sheet by using week numbers, e.g if
i
put week1 in a cell the fixtures for that week will be displayed
--
thanks

Assuming that the week number is in column A and fixtures in column B of
Sheet1 the, select a range of cells on sheet2 for the maximum number of
fixtures, and in the formula bar enter

=IF(ISERROR(SMALL(IF(Sheet1!$A1:$A200=1,ROW($A1:$A 20),""),ROW($A1:$A20))),""
,
INDEX(Sheet1!$B$1:$B$200,SMALL(IF(Sheet1!$A1:$A200 =1,ROW($A1:$A20),""),ROW($
A1:$A20))))

as an array, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike" wrote in message
...
I just need to select some data on one sheet and transfer it to another by
using a number relative to our league weeks.
--
thanks


"Don Guillett" wrote:

First, have a look in help index for weeknum

--
Don Guillett
SalesAid Software

"Mike" wrote in message
...
In a\league schedule i have 18 different weeks of fixtures, is it
possible
to
select a weeks fixtures on a diiferent sheet by using week numbers,
e.g if
i
put week1 in a cell the fixtures for that week will be displayed
--
thanks

EasyFilter have a option to filter on week numbers and copy to a new sheet
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Mike" wrote in message ...
In a\league schedule i have 18 different weeks of fixtures, is it possible to
select a weeks fixtures on a diiferent sheet by using week numbers, e.g if i
put week1 in a cell the fixtures for that week will be displayed
--
thanks