Linking between worksheets

[Guest]

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

 

[Guest]

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.

 

[Guest]

The reference, if on sheet 1, cell a1 would look like the following:

=Sheet1!A1

However, you can keyboard & click your way to the formula.

Move the cell that you want to place the formula in.
Type an = sign to start the formula.

Press <PgUp> to move the sheet 1 and click on the cell you wish to
reference. copy the formula down the column as far as necessary. Repeat as
needed for additional rows or columns.

 

[Stephen]

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?)

 

[Guest]

Hi Stephen, these are test cases for software apps. each worksheet
corresponds to a specific machine we test on, but the test cases are
identical. I could have 5 machines under test, thus 5 worksheets, plus the
master. The test cases are a series of steps to follow and will be identical
for all the machines. For example in columns a thru f, I want those test
cases/steps identical on the other worksheets. There will be an additional
column on the other worksheets, which we record results, but these need to be
specific to that machine, so I wouldnt want any data from other worksheets to
get referenced.
..

 

[Guest]

The general method(s) given by myself, Kevin B and Stephen should work for
you. Just set up the formulas for data entry and calculations individually.

Actually, there is probably a better way. Set up sheet A exactly the way
you want it to be set up, including formulas for cells on that sheet. Then:
Right-click on the sheet's name tab and choose Move or Copy
Pick a place to put the copy of the sheet and be sure and check the Make
Copy option and click OK.
Sheet A will be duplicated and you can give it a new sheet name. Repeat for
as many sheets as you need. Each of the copies will be independent of the
others when it is all done. However, changes in instructions made on one
will NOT be updated on the others, but there's a way around that also!

To make a change in the same cell or group of cells on all sheets in a
workbook:
click the first sheet to make the change to, then hold down the [Ctrl] key
and click the name tabs of any other sheets that you want the same change
applied to. When you have all the sheets you want changed selected (grouped)
make the change(s) - whatever you do to one while they are grouped will be
done to all of them. Be sure to ungroup them when you have finished making
your changes.