View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
 
Posts: 364
Default Linking between worksheets

"mab1963" wrote in message
...
I have a workbook, with two worksheets, A and B, where A is a master
worksheet.
Both have the identical columns and headings.. I want the cells in
worksheet B, to equal the data entered into the cells on the master
worksheet
A. I know I need to either link or reference the two worksheets, but so
far I
am unable to figure this out.
Thanks


In sheet B you put formulas that refer to the equivalent cells in sheet A.
So, for example, in SheetB!B2 you need =SheetA!B2
You can enter this formula in one cell (B2), copy the cell and paste into
all the other cells of interest.

Hope this helps. (I do wonder, though, why do you want two identical
worksheets?)