data transfer

D

dave242006

I created two work sheets. When i put data into sheet one I want it to be
able to automatically copy the same data from selected cells in sheet 1 to
sheet 2
Is this possible ???
If so can anyone help me out here
 
P

pdberger

Dave --
Let's say the 'source' cell (where you type the data) is on Sheet 1, cell
A1. The 'target' cell (where you'd like Excel to update it) is on Sheet 2,
cell B2.

In the 'target' cell, type:

='Sheet1'!A1

HTH
 

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

Need Help with a VBA subroutine 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Section and Page numbering 0
comparing sheet to sheet and adding value 1
selecting workbook/sheet 3
Copy entire row from another sheet onto first sheet if a unique text matches 1
add hyperlink using sheet names and cells(i,j) 3
External cell reference between two excel worksheets both in One Drive 0

Top