K
kevcar40
i am using this formula to return the week number in a header
=INDEX($B$145:$BA$145,0,MAX((B146:BA187<>"")*COLUMN($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
=INDEX($B$145:$BA$145,0,MAX((B146:BA187<>"")*COLUMN($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