This will do it but you should be aware that all the contents of previous tab
will be overwritten and lost.

Sub Copyonetoanother()
Sheets("Previous Tab").Select
Cells.Select
Selection.ClearContents
Sheets("Current Tab").Select
Cells.Select
Selection.Copy
Sheets("Previous Tab").Select
ActiveSheet.Paste
End Sub

"moh" wrote:

Hi,

I have two tabs within one workbook. One is called 'current tab' second one
is called 'previous tab'.

I am trying to create a macro in the current tab that will delete all values
within the 'previous tab' and replace it with the values from the 'current
tab'. In other words, the values in the 'current tab' is moved to 'previous
tab'.

Can anyone help?

Thanks