I have a few sheets I need to work on daily that involve dragging the formulas of the last populated column (e.g column C) to the next column (column D), then copying and pasting the values of column D onto itself. Then the next day I would do the same with column D (dragging the formulas to column E). I use macros and VB for some of the other things but I do this task manually everyday for each sheet because I don't know how to program visual basic to take the last column each time.