ExcelBanter - Have VBA delete a group of cells, move information over, then add

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Have VBA delete a group of cells, move information over, then add (https://www.excelbanter.com/excel-discussion-misc-queries/73237-have-vba-delete-group-cells-move-information-over-then-add.html)

Tina Bradshaw

Have VBA delete a group of cells, move information over, then add

I have a spread sheet that has 13 weeks of information in it. Every Friday I
need to delete the past week, move the remaining information over to the
starting point and then add the dates (sat thru fri) for the new 13th week.
Can we create a VBA formula to do this? If so, could you show me?

All times are GMT +1. The time now is 09:01 AM.