COPYING DATA FROM ONE SHEET TO ANOTHEr
 

what formula can i use to copy info in one cell of excell2003 to another cell
on a different sheet

COPYING DATA FROM ONE SHEET TO ANOTHEr
 

Sheets("From Sheet").Range("A1:C20").Copy Sheets("To Sheet").Range("A1")
(or you can use the sheet index number instead of the name)

Glen

"lilrob" wrote in message
...
what formula can i use to copy info in one cell of excell2003 to another
cell
on a different sheet

COPYING DATA FROM ONE SHEET TO ANOTHEr
 

On sheet2 in a cell.....

Enter =Sheet1!A1

When Sheet1 A1 is changed, the value in sheet2 will update.



On Tue, 16 Nov 2004 14:49:38 -0800, lilrob
wrote:

what formula can i use to copy info in one cell of excell2003 to another cell
on a different sheet