Why don't you just copy the worksheet?
--
ChrisJ
Omaha


"mab1963" wrote:

Thanks.. I understand how to link a cell in one sheet , to a cell in another,
and that they both need to be open at the same time. Problem is, I need to
link multiple cells in a worksheet, to the exact same cells in another
worksheet. So I want rows 4 thru 44, but only columns A thru F.
I just want the values and the formatting to be the same as the values and
formatting on the source sheet. The paste link works, except, all formatting
is lost, and blank cells come across as 0

Thanks again for your response..
Mark

"pdberger" wrote:

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