hi
i have a table of data that is overwritten every week
the table starts in b2 and ends in column and ends in bb65
this data is imported from access via a macro

what i want to do is
on week one copy the data in range c2 : c65 paste it in b 100
the next time i run the macro i want to copy d2:d65 and paste it in b
100
and so on all year
how do i

change the range via formula or vb ?

the copy/ paste actions will take place off a button

thanks

kevin