views:

143

answers:

1

Hi all,

An excel sheet (sheet 1), gets updated on a daily basis by the Admin dept. I need to copy this data in sheet 1 to sheet 2 automatically in the same workbook.

Is this possible?

If so, pls help me with this.

Thanks in advance.

+4  A: 

In a vba macro you can run the following code

Worksheets("Sheet1").UsedRange.Copy Destination:=Worksheets("Sheet2").range("A1")
astander