Copy data to another spreadsheet

  • Thread starter Thread starter JIm
  • Start date Start date
J

JIm

I currently have to copy and paste data from one spreadsheet to another. Is
there a formula that I can write that would automatically copy the data that
I enter in a cell on spreadsheet one to a corresponding cell on spreadsheet
two.

Thanks,
 
Hold Shift key and select Sheet2
When you type in sheet1 it also enter in sheet2

or
=Sheet1!A1
 
You could also link cells across sheets in this manner ..

In Sheet2,

Put in B2:
=IF(Sheet1!B2="","",Sheet1!B2)

Copy B2 across and fill down as required
to link to the corresponding range in Sheet1
 
Back
Top