Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Here's the easy way:
Go to sheet B, click in cell A1 (I'm assuming your information on the A sheet starts in A1). Type in an = symbol into sheet B, cell A1 Choose the A sheet, click in cell A1 and press the [Enter] key. You've just linked sheet B, cell A1 to sheet A, cell A1. If you look at the formula in sheet B, cell A1, you will see something like =A!$A$1 where "A" is the sheet name If you will edit this and delete the $ symbols in the formula, you can then fill to the left and then down the sheet to automatically pick up all values from sheet A. To find out more about how to fill, use Excel Help and search for Fill Data in worksheet cells and you will get detailed instructions on several ways to do it. "mab1963" wrote: 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 |
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 |