View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Linking between worksheets

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