Below is a macro I'm trying to create. The basically it's supposed to be a quick simple macro to save lots of time. I want to select current tab, move/copy (create copy) to the end....then select the tab I've just copied and copy paste special the values (then rename the tab to todays date) FYI the tab I'm copying is called rebuy shipping.
However, I want to then do the same at a later date with the most recent tab, but with the below code it always selects and copies the original tab:
' macrorebuy1 Macro
' Keyboard Shortcut: Ctrl+k
Sheets("Rebuy Shipping").Copy Before:=Sheets(4)
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
Application.CutCopyMode = False
I assume this is a simple error. I've tried inserting Activesheet.previous but I'm doing something wrong! Please help!