I am trying to do the following.
Once a week I need five columns to be copied from one worksheet into another.
So so, when the 17th October is reached, column A,B,C are copied from worksheet A across to worksheet B.
In worksheet B, the copied columns would be placed in column A,B,C in the first week.
The other point is that the copied information has formula behind the cells. I want the cell content to be copied but not the
formula, to prevent auto updating between worksheets.!
For the next week when the 24th Oct (e.g.) came around, column A,B,C of worksheetA would be copied again across to worksheet
B, but would be placed in D,E,F alongside the previous weeks work . This sequence would continue for five weeks.
Then when week 6 arrived , the original week 1 data would be deleted, and worksheet B would now contain weeks 2-6 columns.
This would be a rolling sequence.
Help!! I am not sure if this is possible but hopefully an expert is out there