help linking multiple cells

[pegman]

I'm back and going spreadsheet crazy... learning most from the help section
but...

I have one worksheet that has multiple cells of data in a single row and a
second worksheet that I want to import that data into. If I enter a new value
into one specific cell on the second worksheet I need all the other cells to
change to the new row that contains the optional data from the first
worksheet. I really need to take a basics coures on Excel!!! I've already
established correct column/row from the first worksheet to the corresponding
cells on the second worksheet but don't know how to make the cells update.
Basically a mailmerge between two worksheets

Scott

 

[Suleman Peerzade]

Hi

For eg you have data in row A2:L2 in Sheet 1 and you want to import that
data into Sheet 2 A2:L2.
Now if you want to enter data in Sheet 2,Cell M2 you want that data to
appear in Sheet 1 M2. If yes
Then simple formula to put in sheet 1 cell M2 is
=Sheet 2!M2
Now if you enter any kind of data (Numeric or text) in sheet 2 cell M2 that
will reflect in sheet 1,M2. futher you can drag this formula in that row to
the extent you want.