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.
..

"Stephen" wrote:

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