automatically special paste each week?
 

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

automatically special paste each week?
 

Hi
try recording a macro while doing this manually :-)

--
Regards
Frank Kabel
Frankfurt, Germany


Kirby wrote:
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

automatically special paste each week?
 

Hi
try recording a macro while doing this manually :-)

--
Regards
Frank Kabel
Frankfurt, Germany


Kirby wrote:
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