Did the answers from yesterday not work for you?

http://tinyurl.com/78tug

Regards
Rowan

"PCOR" wrote:

Hi
I have data in col a/b/c/d/e/f/g/h and I
I would like to have a macro that will copy this data: the catch: the bottom
row varies from week to week. Some times it is row 25 and the following week
it could be row 40.
I want to copy that data to an other sheet
Help would be appreciated.