mab --

The easiest way is to open both workbooks. In the "target" cell in Test
Suite, start a formula by typing an '=' sign, then click on the 'source' cell
in the other workbook. Done.

Two things to keep in mind -- the other workbook has to be open for Test
Suite to go get the data. And this setup is not very robust -- if you move
the workbooks or send them to someone else, the links may not work. If you
want to do that, you'll need some VBA code so it goes to the same place each
time to get the source data.

HTH

"mab1963" wrote:

I have one workbook I call test suite. I need to reference a worksheet from
other workbooks which are test cases for software products. then autopoulate
a worksheet in the test suite workbook. The formatting is the same for all
the worksheets, including the suite worksheet. No calcuations are needed, I
just want the data in the suite worksheet, to match the data in the other
worksheets. Basically working the same way as grouping worksheets in a file,
if I update one worksheet, it will automatically update all the worksheets.
The thought is, once it's programmed, anytime I open the suite workbook, I
can update it, to pull the data from the other workbooks worksheets (test
cases). Thank You