Auto populate one worksheet from other worksheets

[mab1963]

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

 

[pdberger]

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]

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

 

[ChrisJ]

Why don't you just copy the worksheet?

 

[Pete_UK]

A formula cannot copy a format from one cell to another, so in A4 of your
destination sheet enter this formula:

=IF(Sheet1!A4="","",Sheet1!A4)

This will avoid getting 0 from blank cells. Copy this across into B4:F4,
then copy A4:F4 down to row 44.

Then in Sheet1 (your source sheet) highlight cells A4:F44 and click <copy>,
then click over to cell A4 of your destination sheet and Edit | Paste
Special | Formats (check) | OK then <Esc>.

You might still need to adjust column widths in the destination sheet, but
this should give you what you want.

Hope this helps.

Pete