Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"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?) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
linking across worksheets | Excel Worksheet Functions | |||
linking worksheets | New Users to Excel | |||
linking worksheets | Excel Discussion (Misc queries) | |||
Linking worksheets | Excel Worksheet Functions | |||
Linking worksheets | Links and Linking in Excel |