"All" values..........?

Record yourself deleting "previous" sheet and making a copy of "current" sheet.


Gord Dibben MS Excel MVP

On Thu, 1 Mar 2007 02:50:00 -0800, 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