Automate These Steps

[ssjagger]

Can someone help me with this? I've been trying to automate the following steps but can't get it to work correctly? I'm working with Excel 2007

I've included a snippet of the spreadsheet I'm working with and these are the following steps:

Step 1: Copy and paste "value" in cell G13 to cell F13
Step 2: Copy and paste G13:BZ13 to G14:BZ14
Step 3: Delete values in G13:BZ13
Repeat steps 1 - 3 until spreadsheet is done.

Thanks

[José Augusto]

Hi
Try these macro. It´s break when value in column F stabilizes

Please Login or Register  to view this content.

see the file

[José Augusto]

Hi
Try these macro. It´s break when value in column F stabilizes

Please Login or Register  to view this content.

see the file 4numbers-1.xlsm

[ssjagger]

Excellent, that works great!