VB Code to reorganize data in a sheet

Hello:

Please refer to attached file.
I have daily data as shown.
Each day has 4 columns of data.
Day 1 : Column O:R
Day 2 : Column S:V
and so on until 31st

I need VB Code to organize the data as below.
For each day i need PLU# data until row 598 to be cut and paste at row 65.
So for
Day 1 : Cut Range(O203:R598) and paste at O65
Day 2 : Cut Range(S215:V598) and paste at S65
Day 3 : Cut Range(W203:Z598) and paste at W65
and so on...

Let me know if you have any questions.
Thanks.

Riz

This is another way:

Please Login or Register  to view this content.