Thank you in advance for your help. I have a sales spreadsheet that
tracks weekly sales data contained in another spreadsheet. The sales
spreadsheet is cotains formulas that pull the sales data from the
other sheet, therefore each week after the spreadsheet has pulled the
current weeks sales data I have to special past the data as values so
that data won't change. The sales spreadsheet is set up so that each
column holds one weeks worth of sales data, as follows:

Week 1 Week 2 Week 3
20 30 40
22 32 42

Is there a macro that will automatically special paste the next column
each week?

Thank,

Kirby