i am using this formula to return the week number in a header

=INDEX($B$145:$BA$145,0,MAX((B146:BA187<"")*COLUM N($B$145:$BA
$187))-1)

what i would like to do is
identify the column address that matches the week number ie column G
(this will change from week to week)
then i would like to select a range eg row 146 to row 190
copy this range
paste it on another sheet
next week G would change to H

any ideas thanks

kevin

I'm afraid this is not a well composed question. You expect us to solve a
puzzle (your data layout) before getting chance to answer it.

Sorry if only I can't figure out the question and others have a different
opinion, then next time I'll skip such posts!

Regards,
Stefi

€žkevcar40€� ezt Ã*rta:

i am using this formula to return the week number in a header

=INDEX($B$145:$BA$145,0,MAX((B146:BA187<"")*COLUM N($B$145:$BA
$187))-1)

what i would like to do is
identify the column address that matches the week number ie column G
(this will change from week to week)
then i would like to select a range eg row 146 to row 190
copy this range
paste it on another sheet
next week G would change to H

any ideas thanks

kevin

On 20 Feb, 12:33, Stefi wrote:
I'm afraid this is not a well composed question. You expect us to solve a
puzzle (your data layout) before getting chance to answer it.

Sorry if only I can't figure out the question and others have a different
opinion, then next time I'll skip such posts!

Regards,
Stefi

„kevcar40” ezt írta:



i am using this formula to return the week number in a header

=INDEX($B$145:$BA$145,0,MAX((B146:BA187<"")*COLUM N($B$145:$BA
$187))-1)

what i would like to do is
identify the column address that matches the week number ie column G
(this will change from week to week)
then i would like to select a range eg row 146 to row 190
copy this range
paste it on another sheet
next week G would change to *H

any ideas thanks

kevin- Hide quoted text -

- Show quoted text -

Sorry if i confused you

every week data is automatically loaded into a table
the table starts in column B (week 1)
the following week the data is automatically loaded into column C
(week 2)
this will continue until column BA(Week52)
B C D E F G .................... AB
Week 1 2 3 4 5 6 52

i have put the date in A1 in b1 i get the week number from the date

i use this formula to identify the last week number with data

=INDEX($B$145:$BA$145,0,MAX((B146:BA187<"")*COLUM N($B$145:$BA
$187))-1)

13/2/2009 6


so what i want to do is look along the weeknumbers when it matches the
week number
copy the range under the week number eg row 146 to row 190
so for week 6 i would want to copy g146:g190

week 7 i would want to copy h146:h190

hope this clears up what i trying


thanks

kev