COPYING DATA FROM ONE SHEET TO ANOTHEr

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

what formula can i use to copy info in one cell of excell2003 to another cell
on a different sheet
 
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
 
On sheet2 in a cell.....

Enter =Sheet1!A1

When Sheet1 A1 is changed, the value in sheet2 will update.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create if partial match then copy and paste data from one cell to another 1
Copy adjacent Sheet and name from a list 42
Copying Data from One sheet to another 6
Progressive number in different sheets 7
Excel Move or Copy Stopped Working? 0
Auto copy cell data from source sheet to another wrkbook sheet 2
Want code to copy to ABOVE row 22 column A on sheet 1 10
Moving data to another sheet 1

Back
Top